GET https://www.leroy.goconcept8.be/booking/product/GBLONTLG/20261229

Query Metrics

4 Database Queries
4 Different statements
0.83 ms Query time
0 Invalid entities
4 Managed entities

Queries

Group similar statements

default connection

#▲ Time Info
1 0.26 ms
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:
[
  "GBLONTLG"
  "product"
]
2 0.25 ms
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:
[
  "GBLONTLG"
  1
]
3 0.17 ms
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:
[
  7494
]
4 0.15 ms
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"
  7494
]

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