Query Metrics
38
Database Queries
6
Different statements
12.56 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
4.34 ms (34.55%) |
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 f1_.slug = 'no') OR f1_.slug = 'sv' OR f1_.slug = 'ss' OR f1_.slug = 'pa' OR f1_.slug = 'main') AND f0_.deleted IS NULL ORDER BY f0_.start ASC
Parameters:
[
"2025-04-29 18:45:36"
]
|
3.90 ms (31.02%) |
33 |
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:
[ "spectacles-speciaux" "fr" ] |
1.98 ms (15.76%) |
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.venue_type_id IN (?) ORDER BY t0.start ASC
Parameters:
[ [ 3 8 23 24 33 34 ] ] |
1.16 ms (9.21%) |
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.url = ? AND t0.locale = ? LIMIT 1
Parameters:
[ "special-dates" "en" ] |
0.64 ms (5.12%) |
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:
[ [ 1 7 9 14 11 20 27 32 35 36 38 37 ] ] |
0.54 ms (4.33%) |
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:
[] |
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.
Entities Mapping
Class | Mapping errors |
---|---|
App\Framework\AppBundle\Entity\Page | No errors. |
App\Framework\AppBundle\Entity\Venue | No errors. |
App\Framework\AppBundle\Entity\Concert | No errors. |
App\Framework\AppBundle\Entity\VenueType | No errors. |
App\Framework\AppBundle\Entity\Places | No errors. |
App\Framework\AppBundle\Entity\Translation | No errors. |