Query Metrics

37 Database Queries
7 Different statements
30.08 ms Query time
0 Invalid entities
925 Managed entities

Grouped Statements

Show all queries

Time Count Info
17.65 ms
(58.68%)
31
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.url AS url_4, t0.content AS content_5, t0.is_home AS is_home_6, t0.is_cms AS is_cms_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM framework_page t0 WHERE t0.slug = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  "accueil"
  "de"
]
4.17 ms
(13.86%)
1
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.content AS content_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM framework_translation t0
Parameters:
[]
3.67 ms
(12.19%)
1
SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.slug AS slug_2, f0_.description AS description_3, f0_.thumbnail AS thumbnail_4, f0_.start AS start_5, f0_.end AS end_6, f0_.season AS season_7, f0_.force_day AS force_day_8, f0_.deleted AS deleted_9, f0_.created_at AS created_at_10, f0_.updated_at AS updated_at_11, f0_.is_full AS is_full_12, f0_.concert_id AS concert_id_13, f0_.venue_type_id AS venue_type_id_14 FROM framework_venue f0_ LEFT JOIN framework_venue_type f1_ ON f0_.venue_type_id = f1_.id WHERE f0_.start > ? AND f0_.deleted IS NULL ORDER BY f0_.start ASC
Parameters:
[
  "2025-10-27 23:17:10"
]
1.79 ms
(5.95%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.thumbnail AS thumbnail_5, t0.start AS start_6, t0.end AS end_7, t0.season AS season_8, t0.force_day AS force_day_9, t0.deleted AS deleted_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_full AS is_full_13, t0.concert_id AS concert_id_14, t15.id AS id_16, t15.title AS title_17, t15.description AS description_18, t15.thumbnail AS thumbnail_19, t15.infos AS infos_20, t15.start AS start_21, t15.end AS end_22, t15.published AS published_23, t15.created_at AS created_at_24, t15.updated_at AS updated_at_25, t0.venue_type_id AS venue_type_id_26, t27.id AS id_28, t27.slug AS slug_29, t27.title AS title_30, t27.description AS description_31, t27.thumbnail AS thumbnail_32, t27.season AS season_33, t27.position AS position_34, t27.food AS food_35, t27.created_at AS created_at_36, t27.updated_at AS updated_at_37 FROM framework_venue t0 LEFT JOIN framework_concert t15 ON t0.concert_id = t15.id LEFT JOIN framework_venue_type t27 ON t0.venue_type_id = t27.id WHERE t0.title = ? LIMIT 1
Parameters:
[
  "Mégaconcert"
]
1.08 ms
(3.58%)
1
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.url AS url_4, t0.content AS content_5, t0.is_home AS is_home_6, t0.is_cms AS is_cms_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM framework_page t0 WHERE t0.is_home = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  1
  "fr"
]
1.01 ms
(3.37%)
1
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.title AS title_3, t0.description AS description_4, t0.thumbnail AS thumbnail_5, t0.season AS season_6, t0.position AS position_7, t0.food AS food_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM framework_venue_type t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  32
  40
  34
  35
  36
  33
  38
  37
]
0.71 ms
(2.37%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.thumbnail AS thumbnail_4, t0.infos AS infos_5, t0.start AS start_6, t0.end AS end_7, t0.published AS published_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM framework_concert t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  18
  24
  19
  20
  21
  22
  23
]

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\Framework\AppBundle\Entity\Translation 659
App\Framework\AppBundle\Entity\Venue 233
App\Framework\AppBundle\Entity\Page 16
App\Framework\AppBundle\Entity\VenueType 9
App\Framework\AppBundle\Entity\Concert 8