GET https://nancy.curieux.app/agenda/categorie/ete

Response
200 OK
IP
216.73.216.109
Profiled on
Token
773d5b

Query Metrics

19 Database Queries
11 Different statements
190.74 ms Query time
1 Invalid entities
175 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
84.04 ms
(44.06%) 		1 
SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.slug AS slug_2, e0_.price AS price_3, e0_.precision_price AS precision_price_4, e0_.date_start AS date_start_5, e0_.date_end AS date_end_6, e0_.time_start AS time_start_7, e0_.time_end AS time_end_8, e0_.precision_date AS precision_date_9, e0_.choice_of_days AS choice_of_days_10, e0_.description AS description_11, e0_.cover_image AS cover_image_12, e0_.created_at AS created_at_13, e0_.updated_at AS updated_at_14, e0_.place_temporary AS place_temporary_15, e0_.is_validated AS is_validated_16, e0_.is_canceled AS is_canceled_17, e0_.is_published AS is_published_18, e0_.is_spam AS is_spam_19, e0_.is_mistake AS is_mistake_20, e0_.is_duplicated AS is_duplicated_21, e0_.is_full AS is_full_22, e0_.is_postponed AS is_postponed_23, e0_.links AS links_24, e0_.oldserial AS oldserial_25, e0_.mail_anonymous AS mail_anonymous_26, e0_.ip_anonymous AS ip_anonymous_27, e0_.secret_anonymous AS secret_anonymous_28, e0_.date_multiple AS date_multiple_29, e0_.time_open AS time_open_30, r1_.id AS id_31, r1_.name AS name_32, r1_.slug AS slug_33, r1_.color AS color_34, r1_.single AS single_35, r1_.plural AS plural_36, p2_.id AS id_37, p2_.title AS title_38, p2_.slug AS slug_39, p2_.cover_image AS cover_image_40, p2_.description AS description_41, p2_.pronoun AS pronoun_42, p2_.name AS name_43, p2_.number AS number_44, p2_.address AS address_45, p2_.created_at AS created_at_46, p2_.updated_at AS updated_at_47, p2_.oldserial AS oldserial_48, p2_.oldurl AS oldurl_49, p2_.opening AS opening_50, p2_.links AS links_51, p2_.map_url AS map_url_52, p2_.street_url AS street_url_53, p2_.email AS email_54, p2_.phone AS phone_55, p2_.ip AS ip_56, p2_.transport AS transport_57, p2_.data_link AS data_link_58, p2_.opinion AS opinion_59, p2_.summary AS summary_60, p2_.wifi AS wifi_61, p2_.last_service AS last_service_62, p2_.parking AS parking_63, p2_.multi_titles AS multi_titles_64, p2_.latitude AS latitude_65, p2_.longitude AS longitude_66, c3_.id AS id_67, c3_.name AS name_68, c3_.slug AS slug_69, c3_.description AS description_70, c3_.coat_of_arms AS coat_of_arms_71, c3_.latitude AS latitude_72, c3_.longitude AS longitude_73, c4_.id AS id_74, c4_.name AS name_75, c4_.slug AS slug_76, c4_.description AS description_77, c4_.coat_of_arms AS coat_of_arms_78, c4_.latitude AS latitude_79, c4_.longitude AS longitude_80, c5_.id AS id_81, c5_.name AS name_82, c5_.slug AS slug_83, v6_.id AS id_84, v6_.url AS url_85, v6_.caption AS caption_86, v7_.id AS id_87, v7_.name AS name_88, v7_.website AS website_89, v7_.embed AS embed_90, v7_.shortcut AS shortcut_91, v7_.linked AS linked_92, t8_.id AS id_93, t8_.url AS url_94, t8_.price AS price_95, t8_.information AS information_96, t9_.id AS id_97, t9_.name AS name_98, t9_.website AS website_99, t9_.embed AS embed_100, t9_.setting AS setting_101, t9_.source AS source_102, t9_.linked AS linked_103, t9_.domain AS domain_104, t9_.redirections AS redirections_105, t9_.is_activated AS is_activated_106, t9_.is_embeddable AS is_embeddable_107, t9_.is_only_responsive AS is_only_responsive_108, e0_.city_id AS city_id_109, e0_.place_id AS place_id_110, e0_.rubric_id AS rubric_id_111, e0_.organizer_id AS organizer_id_112, e0_.festival_id AS festival_id_113, e0_.author_id AS author_id_114, e0_.verified_by_id AS verified_by_id_115, p2_.city_id AS city_id_116, p2_.district_id AS district_id_117, p2_.postcode_id AS postcode_id_118, p2_.placekind_primary_id AS placekind_primary_id_119, p2_.placekind_secondary_id AS placekind_secondary_id_120, p2_.placekind_tertiary_id AS placekind_tertiary_id_121, p2_.author_id AS author_id_122, c3_.borough_id AS borough_id_123, c3_.department_id AS department_id_124, c4_.borough_id AS borough_id_125, c4_.department_id AS department_id_126, v6_.videostore_id AS videostore_id_127, v6_.event_id AS event_id_128, t8_.event_id AS event_id_129, t8_.ticketing_id AS ticketing_id_130 FROM event e0_ LEFT JOIN rubric r1_ ON e0_.rubric_id = r1_.id LEFT JOIN place p2_ ON e0_.place_id = p2_.id LEFT JOIN city c3_ ON p2_.city_id = c3_.id LEFT JOIN city c4_ ON e0_.city_id = c4_.id LEFT JOIN event_category e10_ ON e0_.id = e10_.event_id LEFT JOIN category c5_ ON c5_.id = e10_.category_id LEFT JOIN video v6_ ON e0_.id = v6_.event_id LEFT JOIN videostore v7_ ON v6_.videostore_id = v7_.id LEFT JOIN ticket t8_ ON e0_.id = t8_.event_id LEFT JOIN ticketing t9_ ON t8_.ticketing_id = t9_.id LEFT JOIN borough b11_ ON c4_.borough_id = b11_.id LEFT JOIN subdomain_borough s13_ ON b11_.id = s13_.borough_id LEFT JOIN subdomain s12_ ON s12_.id = s13_.subdomain_id LEFT JOIN borough b14_ ON c3_.borough_id = b14_.id LEFT JOIN subdomain_borough s16_ ON b14_.id = s16_.borough_id LEFT JOIN subdomain s15_ ON s15_.id = s16_.subdomain_id LEFT JOIN event_category e18_ ON e0_.id = e18_.event_id LEFT JOIN category c17_ ON c17_.id = e18_.category_id WHERE e0_.is_published = 1 AND e0_.is_validated = 1 AND ((s12_.slug = ? OR s15_.slug = ?)) AND e0_.date_end >= ? AND c17_.slug = ? ORDER BY e0_.date_start ASC, e0_.time_start ASC, e0_.date_end ASC, e0_.time_end ASC
Parameters: 
[
  "nancy"
  "nancy"
  "2026-08-14"
  "ete"
]
View formatted query    View runnable query    Explain query    View query backtrace
22.94 ms
(12.03%) 		1 
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.slogan AS slogan_3, s0_.color AS color_4, s0_.resident AS resident_5, s0_.network AS network_6, s0_.is_created AS is_created_7, s0_.is_activated AS is_activated_8, s0_.created_at AS created_at_9, s0_.data AS data_10, s0_.legal AS legal_11, s0_.wallpaper AS wallpaper_12, s0_.statistical AS statistical_13, s0_.manager_id AS manager_id_14, s0_.main_borough_id AS main_borough_id_15 FROM subdomain s0_ INNER JOIN subdomain_borough s2_ ON s0_.id = s2_.subdomain_id INNER JOIN borough b1_ ON b1_.id = s2_.borough_id INNER JOIN city c3_ ON b1_.id = c3_.borough_id INNER JOIN event e4_ ON c3_.id = e4_.city_id WHERE e4_.date_end >= ? GROUP BY s0_.id HAVING COUNT(e4_.id) > 0 ORDER BY COUNT(e4_.id) DESC
Parameters: 
[
  "2026-08-14"
]
View formatted query    View runnable query    Explain query    View query backtrace
21.35 ms
(11.19%) 		1 
SELECT c0_.slug AS slug_0, c0_.name AS name_1 FROM city c0_ INNER JOIN event e1_ ON c0_.id = e1_.city_id LEFT JOIN borough b2_ ON c0_.borough_id = b2_.id LEFT JOIN subdomain_borough s4_ ON b2_.id = s4_.borough_id LEFT JOIN subdomain s3_ ON s3_.id = s4_.subdomain_id WHERE e1_.is_published = 1 AND e1_.is_validated = 1 AND e1_.date_end >= ? AND s3_.slug = ? GROUP BY c0_.id ORDER BY c0_.name ASC LIMIT 300
Parameters: 
[
  "2026-08-14"
  "nancy"
]
View formatted query    View runnable query    Explain query    View query backtrace
13.95 ms
(7.31%) 		1 
SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.slug AS slug_2, e0_.price AS price_3, e0_.precision_price AS precision_price_4, e0_.date_start AS date_start_5, e0_.date_end AS date_end_6, e0_.time_start AS time_start_7, e0_.time_end AS time_end_8, e0_.precision_date AS precision_date_9, e0_.choice_of_days AS choice_of_days_10, e0_.description AS description_11, e0_.cover_image AS cover_image_12, e0_.created_at AS created_at_13, e0_.updated_at AS updated_at_14, e0_.place_temporary AS place_temporary_15, e0_.is_validated AS is_validated_16, e0_.is_canceled AS is_canceled_17, e0_.is_published AS is_published_18, e0_.is_spam AS is_spam_19, e0_.is_mistake AS is_mistake_20, e0_.is_duplicated AS is_duplicated_21, e0_.is_full AS is_full_22, e0_.is_postponed AS is_postponed_23, e0_.links AS links_24, e0_.oldserial AS oldserial_25, e0_.mail_anonymous AS mail_anonymous_26, e0_.ip_anonymous AS ip_anonymous_27, e0_.secret_anonymous AS secret_anonymous_28, e0_.date_multiple AS date_multiple_29, e0_.time_open AS time_open_30, r1_.id AS id_31, r1_.name AS name_32, r1_.slug AS slug_33, r1_.color AS color_34, r1_.single AS single_35, r1_.plural AS plural_36, p2_.id AS id_37, p2_.title AS title_38, p2_.slug AS slug_39, p2_.cover_image AS cover_image_40, p2_.description AS description_41, p2_.pronoun AS pronoun_42, p2_.name AS name_43, p2_.number AS number_44, p2_.address AS address_45, p2_.created_at AS created_at_46, p2_.updated_at AS updated_at_47, p2_.oldserial AS oldserial_48, p2_.oldurl AS oldurl_49, p2_.opening AS opening_50, p2_.links AS links_51, p2_.map_url AS map_url_52, p2_.street_url AS street_url_53, p2_.email AS email_54, p2_.phone AS phone_55, p2_.ip AS ip_56, p2_.transport AS transport_57, p2_.data_link AS data_link_58, p2_.opinion AS opinion_59, p2_.summary AS summary_60, p2_.wifi AS wifi_61, p2_.last_service AS last_service_62, p2_.parking AS parking_63, p2_.multi_titles AS multi_titles_64, p2_.latitude AS latitude_65, p2_.longitude AS longitude_66, c3_.id AS id_67, c3_.name AS name_68, c3_.slug AS slug_69, c3_.description AS description_70, c3_.coat_of_arms AS coat_of_arms_71, c3_.latitude AS latitude_72, c3_.longitude AS longitude_73, c4_.id AS id_74, c4_.name AS name_75, c4_.slug AS slug_76, c4_.description AS description_77, c4_.coat_of_arms AS coat_of_arms_78, c4_.latitude AS latitude_79, c4_.longitude AS longitude_80, c5_.id AS id_81, c5_.name AS name_82, c5_.slug AS slug_83, v6_.id AS id_84, v6_.url AS url_85, v6_.caption AS caption_86, v7_.id AS id_87, v7_.name AS name_88, v7_.website AS website_89, v7_.embed AS embed_90, v7_.shortcut AS shortcut_91, v7_.linked AS linked_92, t8_.id AS id_93, t8_.url AS url_94, t8_.price AS price_95, t8_.information AS information_96, t9_.id AS id_97, t9_.name AS name_98, t9_.website AS website_99, t9_.embed AS embed_100, t9_.setting AS setting_101, t9_.source AS source_102, t9_.linked AS linked_103, t9_.domain AS domain_104, t9_.redirections AS redirections_105, t9_.is_activated AS is_activated_106, t9_.is_embeddable AS is_embeddable_107, t9_.is_only_responsive AS is_only_responsive_108, e0_.city_id AS city_id_109, e0_.place_id AS place_id_110, e0_.rubric_id AS rubric_id_111, e0_.organizer_id AS organizer_id_112, e0_.festival_id AS festival_id_113, e0_.author_id AS author_id_114, e0_.verified_by_id AS verified_by_id_115, p2_.city_id AS city_id_116, p2_.district_id AS district_id_117, p2_.postcode_id AS postcode_id_118, p2_.placekind_primary_id AS placekind_primary_id_119, p2_.placekind_secondary_id AS placekind_secondary_id_120, p2_.placekind_tertiary_id AS placekind_tertiary_id_121, p2_.author_id AS author_id_122, c3_.borough_id AS borough_id_123, c3_.department_id AS department_id_124, c4_.borough_id AS borough_id_125, c4_.department_id AS department_id_126, v6_.videostore_id AS videostore_id_127, v6_.event_id AS event_id_128, t8_.event_id AS event_id_129, t8_.ticketing_id AS ticketing_id_130 FROM event e0_ LEFT JOIN rubric r1_ ON e0_.rubric_id = r1_.id LEFT JOIN place p2_ ON e0_.place_id = p2_.id LEFT JOIN city c3_ ON p2_.city_id = c3_.id LEFT JOIN city c4_ ON e0_.city_id = c4_.id LEFT JOIN event_category e10_ ON e0_.id = e10_.event_id LEFT JOIN category c5_ ON c5_.id = e10_.category_id LEFT JOIN video v6_ ON e0_.id = v6_.event_id LEFT JOIN videostore v7_ ON v6_.videostore_id = v7_.id LEFT JOIN ticket t8_ ON e0_.id = t8_.event_id LEFT JOIN ticketing t9_ ON t8_.ticketing_id = t9_.id LEFT JOIN borough b11_ ON c4_.borough_id = b11_.id LEFT JOIN subdomain_borough s13_ ON b11_.id = s13_.borough_id LEFT JOIN subdomain s12_ ON s12_.id = s13_.subdomain_id LEFT JOIN borough b14_ ON c3_.borough_id = b14_.id LEFT JOIN subdomain_borough s16_ ON b14_.id = s16_.borough_id LEFT JOIN subdomain s15_ ON s15_.id = s16_.subdomain_id LEFT JOIN event_category e18_ ON e0_.id = e18_.event_id LEFT JOIN category c17_ ON c17_.id = e18_.category_id WHERE e0_.is_published = 1 AND e0_.is_validated = 1 AND ((s12_.slug = ? OR s15_.slug = ?)) AND e0_.date_end >= ? AND e0_.date_start <= ? AND e0_.date_end >= ? AND c17_.slug = ? ORDER BY e0_.date_start ASC, e0_.time_start ASC, e0_.date_end ASC, e0_.time_end ASC
Parameters: 
[
  "nancy"
  "nancy"
  "2026-08-14"
  "2026-09-13"
  "2026-08-14"
  "ete"
]
View formatted query    View runnable query    Explain query    View query backtrace
12.80 ms
(6.71%) 		1 
SELECT p0_.slug AS slug_0, p0_.title AS title_1 FROM place p0_ LEFT JOIN city c1_ ON p0_.city_id = c1_.id LEFT JOIN borough b2_ ON c1_.borough_id = b2_.id LEFT JOIN subdomain_borough s4_ ON b2_.id = s4_.borough_id LEFT JOIN subdomain s3_ ON s3_.id = s4_.subdomain_id WHERE (EXISTS (SELECT e5_.id FROM event e5_ WHERE e5_.place_id = p0_.id AND e5_.is_published = 1 AND e5_.is_validated = 1 AND e5_.date_end >= ?)) AND s3_.slug = ? ORDER BY p0_.title ASC LIMIT 300
Parameters: 
[
  "2026-08-14 00:00:00"
  "nancy"
]
View formatted query    View runnable query    Explain query    View query backtrace
11.23 ms
(5.89%) 		1 
SELECT COUNT(DISTINCT e0_.id) AS sclr_0 FROM event e0_ LEFT JOIN rubric r1_ ON e0_.rubric_id = r1_.id LEFT JOIN place p2_ ON e0_.place_id = p2_.id LEFT JOIN city c3_ ON e0_.city_id = c3_.id LEFT JOIN city c4_ ON p2_.city_id = c4_.id LEFT JOIN borough b5_ ON c3_.borough_id = b5_.id LEFT JOIN subdomain_borough s7_ ON b5_.id = s7_.borough_id LEFT JOIN subdomain s6_ ON s6_.id = s7_.subdomain_id LEFT JOIN borough b8_ ON c4_.borough_id = b8_.id LEFT JOIN subdomain_borough s10_ ON b8_.id = s10_.borough_id LEFT JOIN subdomain s9_ ON s9_.id = s10_.subdomain_id LEFT JOIN event_category e12_ ON e0_.id = e12_.event_id LEFT JOIN category c11_ ON c11_.id = e12_.category_id WHERE e0_.is_published = 1 AND e0_.is_validated = 1 AND e0_.date_start <= ? AND e0_.date_end >= ? AND ((s6_.slug = ? OR s9_.slug = ?)) AND e0_.date_end >= ? AND c11_.slug = ? AND e0_.date_start >= ?
Parameters: 
[
  "2026-09-13"
  "2026-08-14"
  "nancy"
  "nancy"
  "2026-08-14"
  "ete"
  "2026-08-14"
]
View formatted query    View runnable query    Explain query    View query backtrace
9.31 ms
(4.88%) 		1 
SELECT COUNT(DISTINCT e0_.id) AS sclr_0 FROM event e0_ LEFT JOIN rubric r1_ ON e0_.rubric_id = r1_.id LEFT JOIN place p2_ ON e0_.place_id = p2_.id LEFT JOIN city c3_ ON e0_.city_id = c3_.id LEFT JOIN city c4_ ON p2_.city_id = c4_.id LEFT JOIN borough b5_ ON c3_.borough_id = b5_.id LEFT JOIN subdomain_borough s7_ ON b5_.id = s7_.borough_id LEFT JOIN subdomain s6_ ON s6_.id = s7_.subdomain_id LEFT JOIN borough b8_ ON c4_.borough_id = b8_.id LEFT JOIN subdomain_borough s10_ ON b8_.id = s10_.borough_id LEFT JOIN subdomain s9_ ON s9_.id = s10_.subdomain_id LEFT JOIN event_category e12_ ON e0_.id = e12_.event_id LEFT JOIN category c11_ ON c11_.id = e12_.category_id WHERE e0_.is_published = 1 AND e0_.is_validated = 1 AND ((s6_.slug = ? OR s9_.slug = ?)) AND e0_.date_end >= ? AND c11_.slug = ?
Parameters: 
[
  "nancy"
  "nancy"
  "2026-08-14"
  "ete"
]
View formatted query    View runnable query    Explain query    View query backtrace
6.81 ms
(3.57%) 		7 
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.slogan AS slogan_4, t0.color AS color_5, t0.resident AS resident_6, t0.network AS network_7, t0.is_created AS is_created_8, t0.is_activated AS is_activated_9, t0.created_at AS created_at_10, t0.data AS data_11, t0.legal AS legal_12, t0.wallpaper AS wallpaper_13, t0.statistical AS statistical_14, t0.manager_id AS manager_id_15, t0.main_borough_id AS main_borough_id_16 FROM subdomain t0 WHERE t0.slug = ? LIMIT 1
Parameters: 
[
  "nancy"
]
View formatted query    View runnable query    Explain query    View query backtrace
4.01 ms
(2.10%) 		3 
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM category t0 WHERE t0.slug = ? LIMIT 1
Parameters: 
[
  "ete"
]
View formatted query    View runnable query    Explain query    View query backtrace
3.50 ms
(1.84%) 		1 
SELECT DISTINCT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2 FROM category c0_ INNER JOIN event_category e2_ ON c0_.id = e2_.category_id INNER JOIN event e1_ ON e1_.id = e2_.event_id WHERE e1_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY c0_.id ORDER BY COUNT(e1_.id) DESC, c0_.slug ASC
Parameters: 
[
  135767
  135153
  135738
  135716
  135156
  135769
  135157
  135717
  135718
  135719
  135739
  135771
  135793
  135161
  135742
  135743
  135776
  135744
  135777
  135779
  135745
  135780
  135781
  135782
  135783
  135721
  135746
  135785
  135722
  135787
]
View formatted query    View runnable query    Explain query    View query backtrace
0.80 ms
(0.42%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.resident AS resident_4, t0.chief_town AS chief_town_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.description AS description_8, t0.zoom AS zoom_9, t0.department_id AS department_id_10, t11.id AS id_12, t11.name AS name_13, t11.slug AS slug_14, t11.slogan AS slogan_15, t11.color AS color_16, t11.resident AS resident_17, t11.network AS network_18, t11.is_created AS is_created_19, t11.is_activated AS is_activated_20, t11.created_at AS created_at_21, t11.data AS data_22, t11.legal AS legal_23, t11.wallpaper AS wallpaper_24, t11.statistical AS statistical_25, t11.manager_id AS manager_id_26, t11.main_borough_id AS main_borough_id_27 FROM borough t0 LEFT JOIN subdomain t11 ON t11.main_borough_id = t0.id WHERE t0.id = ?
Parameters: 
[
  185
]
View formatted query    View runnable query    Explain query    View query backtrace

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Ticket 89
App\Entity\Event 30
App\Entity\Subdomain 12
App\Entity\Borough 12
App\Entity\Category 12
App\Entity\Place 5
App\Entity\City 4
App\Entity\User 3
App\Entity\Rubric 3
App\Entity\Ticketing 3
App\Entity\Department 1
App\Entity\Placekind 1

Entities Mapping

Class Mapping errors
App\Entity\Subdomain No errors.
App\Entity\User No errors.
App\Entity\Borough No errors.
App\Entity\Reduction No errors.
App\Entity\Category No errors.
App\Entity\Event No errors.
App\Entity\Rubric No errors.
App\Entity\City
  • The field App\Entity\City#resources is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\TicketResource#city does not contain the required 'inversedBy: "resources"' attribute.
App\Entity\Department No errors.
App\Entity\Place No errors.
App\Entity\Video No errors.
App\Entity\Videostore No errors.
App\Entity\Ticket No errors.
App\Entity\Ticketing No errors.
App\Entity\Organizer No errors.
App\Entity\Festival No errors.
App\Entity\District No errors.
App\Entity\Postcode No errors.
App\Entity\Placekind No errors.
App\Entity\Image No errors.
App\Entity\Comment No errors.
App\Entity\Claim No errors.
App\Entity\EventLike No errors.
App\Entity\Prices No errors.
App\Entity\Artist No errors.
App\Entity\PlaceLike No errors.
App\Entity\Room No errors.
App\Entity\Placetag No errors.
App\Entity\TicketResource No errors.