Query Metrics
3
Database Queries
3
Different statements
0.83 ms
Query time
0
Invalid entities
3
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
0.30 ms (36.89%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.domain AS domain_4, t0.accent_color AS accent_color_5, t0.pip_accessory AS pip_accessory_6, t0.hero_asset AS hero_asset_7, t0.hero_winter_asset AS hero_winter_asset_8, t0.intro AS intro_9, t0.active AS active_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM city t0 WHERE t0.id = ?
Parameters:
[
2
]
|
||||||||||||||||||||||
|
0.28 ms (34.08%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.type AS type_4, t0.body AS body_5, t0.cluster_slug AS cluster_slug_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.meta_title AS meta_title_9, t0.meta_description AS meta_description_10, t0.og_image AS og_image_11, t0.canonical_override AS canonical_override_12, t0.indexable AS indexable_13, t0.status AS status_14, t0.published_at AS published_at_15, t0.checked_at AS checked_at_16, t0.demo AS demo_17, t0.city_id AS city_id_18 FROM guide t0 WHERE t0.city_id = ? AND t0.slug = ? AND t0.type = ? AND t0.status = ? LIMIT 1
Parameters:
[ 2 "eurostar-vanuit-brussel" "praktisch" "published" ]
|
||||||||||||||||||||||
|
0.24 ms (29.04%) |
1 |
SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.sort_order AS sort_order_4, t0.context AS context_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.city_id AS city_id_8, t0.district_id AS district_id_9, t0.place_id AS place_id_10, t0.guide_id AS guide_id_11 FROM faq t0 WHERE t0.guide_id = ? ORDER BY t0.sort_order ASC
Parameters:
[
12
]
|
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\City | 1 |
| App\Entity\Guide | 1 |
| App\Entity\Faq | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\City | No errors. |
| App\Entity\Guide | No errors. |
| App\Entity\Faq | No errors. |
| App\Entity\District | No errors. |
| App\Entity\Place | No errors. |