Query Metrics
4
Database Queries
4
Different statements
1.05 ms
Query time
0
Invalid entities
5
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.30 ms |
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
]
|
||||||||||||||||||||||||||||
| 2 | 0.28 ms |
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.slug AS slug_2, d0_.intro AS intro_3, d0_.description AS description_4, d0_.quick_facts AS quick_facts_5, d0_.fit_scores AS fit_scores_6, d0_.metro_stations AS metro_stations_7, d0_.color AS color_8, d0_.lat AS lat_9, d0_.lng AS lng_10, d0_.created_at AS created_at_11, d0_.updated_at AS updated_at_12, d0_.meta_title AS meta_title_13, d0_.meta_description AS meta_description_14, d0_.og_image AS og_image_15, d0_.canonical_override AS canonical_override_16, d0_.indexable AS indexable_17, d0_.status AS status_18, d0_.published_at AS published_at_19, d0_.checked_at AS checked_at_20, d0_.demo AS demo_21, d0_.city_id AS city_id_22 FROM district d0_ WHERE d0_.city_id = ? AND d0_.slug = ? AND d0_.status = ? LIMIT 1
Parameters:
[ 2 "south-kensington" "published" ]
|
||||||||||||||||||||||||||||
| 3 | 0.27 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.type AS type_4, t0.metro_distance AS metro_distance_5, t0.short_description AS short_description_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, t0.district_id AS district_id_19, t0.affiliate_link_id AS affiliate_link_id_20, t0.cover_image_id AS cover_image_id_21 FROM hotel t0 WHERE t0.district_id = ? AND t0.status = ? ORDER BY t0.name ASC
Parameters:
[ 4 "published" ]
|
||||||||||||||||||||||||||||
| 4 | 0.20 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.destination_url AS destination_url_3, t0.path_params AS path_params_4, t0.click_count AS click_count_5, t0.active AS active_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.partner_id AS partner_id_9 FROM affiliate_link t0 WHERE t0.id = ?
Parameters:
[
6
]
|
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\District | 1 |
| App\Entity\Hotel | 1 |
| App\Entity\AffiliateLink | 1 |
| App\Entity\AffiliatePartner | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\City | No errors. |
| App\Entity\District | No errors. |
| App\Entity\Hotel | No errors. |
| App\Entity\AffiliateLink | No errors. |
| App\Entity\MediaAsset | No errors. |
| App\Entity\AffiliatePartner | No errors. |