GET https://www.curieux.app/agenda/evenement/salon-gourmet-chocolat-le-plaisir-des-papilles

Query Metrics

11 Database Queries
11 Different statements
1356.10 ms Query time
0 Invalid entities
26 Managed entities

Queries

Group similar statements

# Time Info
1 936.83 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.price AS price_4, t0.precision_price AS precision_price_5, t0.date_start AS date_start_6, t0.date_end AS date_end_7, t0.time_start AS time_start_8, t0.time_end AS time_end_9, t0.precision_date AS precision_date_10, t0.choice_of_days AS choice_of_days_11, t0.description AS description_12, t0.cover_image AS cover_image_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.place_temporary AS place_temporary_16, t0.is_validated AS is_validated_17, t0.is_canceled AS is_canceled_18, t0.is_published AS is_published_19, t0.is_spam AS is_spam_20, t0.is_mistake AS is_mistake_21, t0.is_duplicated AS is_duplicated_22, t0.is_full AS is_full_23, t0.is_postponed AS is_postponed_24, t0.links AS links_25, t0.city_id AS city_id_26, t0.place_id AS place_id_27, t0.rubric_id AS rubric_id_28, t0.organizer_id AS organizer_id_29, t0.festival_id AS festival_id_30 FROM event t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "salon-gourmet-chocolat-le-plaisir-des-papilles"
]
2 403.77 ms
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_.main_borough_id AS main_borough_id_7 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:
[
  "2025-10-23"
]
3 0.75 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.color AS color_4, t0.single AS single_5, t0.plural AS plural_6 FROM rubric t0 WHERE t0.id = ?
Parameters:
[
  9
]
4 0.95 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM category t0 INNER JOIN event_category ON t0.id = event_category.category_id WHERE event_category.event_id = ?
Parameters:
[
  131102
]
5 1.47 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.coat_of_arms AS coat_of_arms_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.borough_id AS borough_id_8 FROM city t0 WHERE t0.id = ?
Parameters:
[
  3262
]
6 1.62 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.price AS price_3, t0.information AS information_4, t0.event_id AS event_id_5, t0.ticketing_id AS ticketing_id_6 FROM ticket t0 WHERE t0.event_id = ?
Parameters:
[
  131102
]
7 4.84 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.caption AS caption_3, t0.videostore_id AS videostore_id_4, t0.event_id AS event_id_5 FROM video t0 WHERE t0.event_id = ?
Parameters:
[
  131102
]
8 2.58 ms
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 FROM borough t0 WHERE t0.id = ?
Parameters:
[
  194
]
9 1.81 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.code AS code_4, t0.region_id AS region_id_5 FROM department t0 WHERE t0.id = ?
Parameters:
[
  281
]
10 0.79 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.country_id AS country_id_4 FROM region t0 WHERE t0.id = ?
Parameters:
[
  65
]
11 0.68 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.code AS code_4 FROM country t0 WHERE t0.id = ?
Parameters:
[
  5
]

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\Subdomain 9
App\Entity\Borough 9
App\Entity\Event 1
App\Entity\City 1
App\Entity\Rubric 1
App\Entity\Organizer 1
App\Entity\Category 1
App\Entity\Department 1
App\Entity\Region 1
App\Entity\Country 1

Entities Mapping

Class Mapping errors
App\Entity\Event No errors.
App\Entity\City No errors.
App\Entity\Place No errors.
App\Entity\Rubric No errors.
App\Entity\Organizer No errors.
App\Entity\Festival No errors.
App\Entity\Category No errors.
App\Entity\Ticket No errors.
App\Entity\Video No errors.
App\Entity\Prices No errors.
App\Entity\Artist No errors.
App\Entity\Subdomain No errors.
App\Entity\Borough No errors.
App\Entity\District No errors.
App\Entity\Ticketing No errors.
App\Entity\Videostore No errors.
App\Entity\Department No errors.
App\Entity\Region No errors.
App\Entity\Country No errors.