Query Metrics
4
Database Queries
4
Different statements
14.95 ms
Query time
0
Invalid entities
4
Managed entities
Grouped Statements
default connection
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
12.77 ms (85.40%) |
1 |
SELECT t0.id AS id_1, t0.length AS length_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.travel_description_id AS travel_description_id_5 FROM travel_length t0 WHERE t0.travel_description_id = ?
Parameters:
[
7872
]
|
||||||||||||||||||||||||||||
|
1.20 ms (8.06%) |
1 |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.path AS path_3, t0.entity_type AS entity_type_4, t0.entity_id AS entity_id_5, t0.route_name AS route_name_6, t0.pathauto AS pathauto_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.parent_id AS parent_id_10 FROM url_alias t0 WHERE t0.entity_type = ? AND t0.entity_id = ? LIMIT 1
Parameters:
[ "travel-description" 7872 ] |
||||||||||||||||||||||||||||
|
0.67 ms (4.48%) |
1 |
SELECT t0.id AS id_1, t0.offer_code AS offer_code_2, t0.offer_type AS offer_type_3, t0.unique_price AS unique_price_4, t0.unique_city AS unique_city_5, t0.unique_description AS unique_description_6, t0.unique_division AS unique_division_7, t0.variant_label AS variant_label_8, t0.canonical AS canonical_9, t0.title AS title_10, t0.teaser AS teaser_11, t0.description AS description_12, t0.intro AS intro_13, t0.chapeau1 AS chapeau1_14, t0.chapeau2 AS chapeau2_15, t0.qualite_leo AS qualite_leo_16, t0.entree_site AS entree_site_17, t0.price_comment AS price_comment_18, t0.gifts AS gifts_19, t0.good_to_know AS good_to_know_20, t0.important_info AS important_info_21, t0.duration AS duration_22, t0.duration_only_on_web AS duration_only_on_web_23, t0.minimum_length AS minimum_length_24, t0.is_stay AS is_stay_25, t0.published AS published_26, t0.special_offer_enabled AS special_offer_enabled_27, t0.special_offer_url AS special_offer_url_28, t0.not_in_brochure AS not_in_brochure_29, t0.brochure_page AS brochure_page_30, t0.brochure_column AS brochure_column_31, t0.print_title AS print_title_32, t0.print_intro AS print_intro_33, t0.print_schedule AS print_schedule_34, t0.print_starting_price AS print_starting_price_35, t0.print_price_notes AS print_price_notes_36, t0.print_date AS print_date_37, t0.created_at AS created_at_38, t0.updated_at AS updated_at_39, t0.stay_services AS stay_services_40, t0.stay_room AS stay_room_41, t0.stay_catering AS stay_catering_42, t0.stay_animation AS stay_animation_43, t0.eco_impact_formula AS eco_impact_formula_44, t0.eco_impact_type AS eco_impact_type_45, t0.eco_impact_distance AS eco_impact_distance_46, t0.eco_impact_emissions AS eco_impact_emissions_47, t0.eco_impact_contribution AS eco_impact_contribution_48, t0.seo_title AS seo_title_49, t0.seo_description AS seo_description_50, t0.seo_keywords AS seo_keywords_51, t0.seo_canonical AS seo_canonical_52, t0.seo_key AS seo_key_53, t0.seo_robots AS seo_robots_54, t0.seo_sitemap AS seo_sitemap_55, t0.variant_group_id AS variant_group_id_56, t0.type_id AS type_id_57, t0.brochure_id AS brochure_id_58, t0.print_thematique_id AS print_thematique_id_59 FROM travel_description t0 WHERE t0.offer_code = ? AND t0.published = ? LIMIT 1
Parameters:
[ "ESLL1808" 1 ]
|
||||||||||||||||||||||||||||
|
0.31 ms (2.06%) |
1 |
SELECT t0.id AS id_1, t0.type AS type_2, t0.code AS code_3, t0.description AS description_4, t0.division AS division_5, t0.imported_at AS imported_at_6 FROM travel_offer t0 WHERE t0.code = ? AND t0.type = ? LIMIT 1
Parameters:
[ "ESLL1808" "package" ]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| legacy_east | doctrine.dbal.legacy_east_connection |
| legacy_west | doctrine.dbal.legacy_west_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\UrlAlias | 2 |
| App\Entity\Imported\TravelOffer | 1 |
| App\Entity\TravelDescription | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Imported\TravelOffer | No errors. |
| App\Entity\Embeddable\Stay | No errors. |
| App\Entity\Embeddable\EcoImpact | No errors. |
| App\Entity\Embeddable\Seo | No errors. |
| App\Entity\TravelDescription | No errors. |
| App\Entity\Structural\TravelVariantGroup | No errors. |
| App\Entity\Imported\TravelType | No errors. |
| App\Entity\Brochure | No errors. |
| App\Entity\Thematique | No errors. |
| App\Entity\Travel\TravelHotel | No errors. |
| App\Entity\Travel\TravelProgrammeItem | No errors. |
| App\Entity\Travel\TravelContentTab | No errors. |
| App\Entity\Travel\TravelThematique | No errors. |
| App\Entity\Travel\TravelImage | No errors. |
| App\Entity\Travel\TravelFile | No errors. |
| App\Entity\Travel\TravelLength | No errors. |
| App\Entity\Content | No errors. |
| App\Entity\UrlAlias | No errors. |