Query Metrics
7
Database Queries
3
Different statements
6.93 ms
Query time
1
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.57 ms |
SELECT t0.routing AS routing_1, t0.redirect AS redirect_2, t0.codeRedirect AS codeRedirect_3, t0.id AS id_4 FROM Routing t0 WHERE t0.routing = ? LIMIT 1
Parameters:
[
"/ads.txt"
]
|
| 2 | 2.50 ms |
SELECT DISTINCT t0_.label AS label_0, t0_.subtitle AS subtitle_1, t0_.slug AS slug_2, t0_.code AS code_3, t0_.id AS id_4, e1_.title AS title_5, e1_.subtitle AS subtitle_6, e1_.titleApidae AS titleApidae_7, e1_.idHeartStroke AS idHeartStroke_8, e1_.description AS description_9, e1_.infos AS infos_10, e1_.additionalServices AS additionalServices_11, e1_.distance AS distance_12, e1_.status AS status_13, e1_.slug AS slug_14, e1_.isHome AS isHome_15, e1_.includedInPrice AS includedInPrice_16, e1_.notIncludedInPrice AS notIncludedInPrice_17, e1_.productCode AS productCode_18, e1_.isAccessibleWithoutCar AS isAccessibleWithoutCar_19, e1_.accessibilityWithoutCarDescription AS accessibilityWithoutCarDescription_20, e1_.price AS price_21, e1_.nights AS nights_22, e1_.guests AS guests_23, e1_.dateStart AS dateStart_24, e1_.dateEnd AS dateEnd_25, e1_.hostExperienceNumber AS hostExperienceNumber_26, e1_.year AS year_27, e1_.id AS id_28, e1_.position AS position_29, e1_.created_at AS created_at_30, e1_.updated_at AS updated_at_31, e1_.meta_title AS meta_title_32, e1_.meta_description AS meta_description_33, e1_.og_title AS og_title_34, e1_.og_description AS og_description_35, t0_.visual_id AS visual_id_36, t0_.geomarker_id AS geomarker_id_37, t0_.geomarkerHover_id AS geomarkerHover_id_38, e1_.typology_id AS typology_id_39, e1_.accommodation_id AS accommodation_id_40, e1_.visualMobile_id AS visualMobile_id_41, e1_.cinemagraph_id AS cinemagraph_id_42, e1_.territory_id AS territory_id_43, e1_.season_id_id AS season_id_id_44, e1_.ogImage_id AS ogImage_id_45 FROM Typology t0_ LEFT JOIN Experience e1_ ON t0_.id = e1_.typology_id AND (e1_.typology_id = t0_.id) WHERE e1_.status = ? AND e1_.dateStart <= ? AND e1_.dateEnd >= ?
Parameters:
[ 1 "2024-11-24" "2024-11-24" ] |
| 3 | 0.48 ms |
SELECT t0.title AS title_1, t0.slug AS slug_2, t0.id AS id_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.og_title AS og_title_6, t0.og_description AS og_description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.ogImage_id AS ogImage_id_10 FROM Page t0
Parameters:
[] |
| 4 | 0.39 ms |
SELECT t0.title AS title_1, t0.slug AS slug_2, t0.id AS id_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.og_title AS og_title_6, t0.og_description AS og_description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.ogImage_id AS ogImage_id_10 FROM Page t0
Parameters:
[] |
| 5 | 2.32 ms |
SELECT DISTINCT t0_.label AS label_0, t0_.subtitle AS subtitle_1, t0_.slug AS slug_2, t0_.code AS code_3, t0_.id AS id_4, e1_.title AS title_5, e1_.subtitle AS subtitle_6, e1_.titleApidae AS titleApidae_7, e1_.idHeartStroke AS idHeartStroke_8, e1_.description AS description_9, e1_.infos AS infos_10, e1_.additionalServices AS additionalServices_11, e1_.distance AS distance_12, e1_.status AS status_13, e1_.slug AS slug_14, e1_.isHome AS isHome_15, e1_.includedInPrice AS includedInPrice_16, e1_.notIncludedInPrice AS notIncludedInPrice_17, e1_.productCode AS productCode_18, e1_.isAccessibleWithoutCar AS isAccessibleWithoutCar_19, e1_.accessibilityWithoutCarDescription AS accessibilityWithoutCarDescription_20, e1_.price AS price_21, e1_.nights AS nights_22, e1_.guests AS guests_23, e1_.dateStart AS dateStart_24, e1_.dateEnd AS dateEnd_25, e1_.hostExperienceNumber AS hostExperienceNumber_26, e1_.year AS year_27, e1_.id AS id_28, e1_.position AS position_29, e1_.created_at AS created_at_30, e1_.updated_at AS updated_at_31, e1_.meta_title AS meta_title_32, e1_.meta_description AS meta_description_33, e1_.og_title AS og_title_34, e1_.og_description AS og_description_35, t0_.visual_id AS visual_id_36, t0_.geomarker_id AS geomarker_id_37, t0_.geomarkerHover_id AS geomarkerHover_id_38, e1_.typology_id AS typology_id_39, e1_.accommodation_id AS accommodation_id_40, e1_.visualMobile_id AS visualMobile_id_41, e1_.cinemagraph_id AS cinemagraph_id_42, e1_.territory_id AS territory_id_43, e1_.season_id_id AS season_id_id_44, e1_.ogImage_id AS ogImage_id_45 FROM Typology t0_ LEFT JOIN Experience e1_ ON t0_.id = e1_.typology_id AND (e1_.typology_id = t0_.id) WHERE e1_.status = ? AND e1_.dateStart <= ? AND e1_.dateEnd >= ?
Parameters:
[ 1 "2024-11-24" "2024-11-24" ] |
| 6 | 0.31 ms |
SELECT t0.title AS title_1, t0.slug AS slug_2, t0.id AS id_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.og_title AS og_title_6, t0.og_description AS og_description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.ogImage_id AS ogImage_id_10 FROM Page t0
Parameters:
[] |
| 7 | 0.34 ms |
SELECT t0.title AS title_1, t0.slug AS slug_2, t0.id AS id_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.og_title AS og_title_6, t0.og_description AS og_description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.ogImage_id AS ogImage_id_10 FROM Page 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\Entity\Typology |
|
| App\Entity\Page | No errors. |
| App\Entity\Review | No errors. |
| App\Entity\Routing | No errors. |
| App\Entity\Experience | No errors. |
| Sonata\MediaBundle\Entity\BaseMedia | No errors. |
| App\Application\Sonata\MediaBundle\Entity\Media | No errors. |
| App\Entity\Accommodation | No errors. |
| App\Entity\Territory | No errors. |
| App\Entity\Season | No errors. |
| App\Entity\PageContent | No errors. |