GET https://www.leroy.goconcept8.be/destinations/pays/japon

Query Metrics

151 Database Queries
24 Different statements
488.17 ms Query time
0 Invalid entities
132 Managed entities

Grouped Statements

Show all queries

default connection

Time▼ Count Info
146.92 ms
(30.10%)
11
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:
[
  "country"
  308
]
96.81 ms
(19.83%)
57
SELECT t0.id AS id_1, t0.label AS label_2, t0.external_url AS external_url_3, t0.target AS target_4, t0.position AS position_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8, t0.menu_id AS menu_id_9, t0.url_alias_id AS url_alias_id_10 FROM menu_link t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC
Parameters:
[
  676
]
71.35 ms
(14.62%)
27
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.id = ?
Parameters:
[
  8806
]
41.04 ms
(8.41%)
4
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.caption AS caption_3, t0.type AS type_4, t0.position AS position_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.travel_description_id AS travel_description_id_8 FROM travel_image t0 WHERE t0.travel_description_id = ?
Parameters:
[
  7385
]
30.18 ms
(6.18%)
4
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.subtitle AS subtitle_2, t0_.intro AS intro_3, t0_.thumb_label AS thumb_label_4, t0_.image AS image_5, t0_.image_header AS image_header_6, t0_.tooltip AS tooltip_7, t0_.tooltip_link AS tooltip_link_8, t0_.highlighted AS highlighted_9, t0_.active AS active_10, t0_.position AS position_11, t0_.created_at AS created_at_12, t0_.updated_at AS updated_at_13, t0_.seo_title AS seo_title_14, t0_.seo_description AS seo_description_15, t0_.seo_keywords AS seo_keywords_16, t0_.seo_canonical AS seo_canonical_17, t0_.seo_key AS seo_key_18, t0_.seo_robots AS seo_robots_19, t0_.seo_sitemap AS seo_sitemap_20, t0_.taxonomy_id AS taxonomy_id_21, t0_.logo_id AS logo_id_22 FROM travel_term t0_ WHERE EXISTS (SELECT 1 FROM travel_description_travel_term t1_ WHERE t1_.travel_term_id = t0_.id AND t1_.travel_description_id IN (?)) AND t0_.active = 1 ORDER BY t0_.position ASC LIMIT 4
Parameters:
[
  7385
]
27.38 ms
(5.61%)
3
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 = ? LIMIT 1
Parameters:
[
  "BFREDFR"
]
22.67 ms
(4.64%)
3
SELECT t0.id AS id_1, t0.label AS label_2, t0.external_url AS external_url_3, t0.target AS target_4, t0.position AS position_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8, t0.menu_id AS menu_id_9, t0.url_alias_id AS url_alias_id_10 FROM menu_link t0 WHERE t0.menu_id = ? AND t0.parent_id IS NULL ORDER BY t0.position ASC
Parameters:
[
  4
]
9.97 ms
(2.04%)
4
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.min_width AS min_width_4 FROM breakpoint t0 WHERE t0.id = ?
Parameters:
[
  1
]
9.05 ms
(1.85%)
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 INNER JOIN travel_description_country ON t0.id = travel_description_country.travel_description_id WHERE travel_description_country.country_id = ?
Parameters:
[
  308
]
8.27 ms
(1.69%)
2
SELECT t0.id AS id_1, t0.slot AS slot_2, t0.content_id AS content_id_3 FROM content_display_slot t0 WHERE t0.content_id = ?
Parameters:
[
  348
]
4.83 ms
(0.99%)
10
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.width AS width_4, t0.height AS height_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM image_style t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "header-small"
]
3.78 ms
(0.77%)
2
SELECT t0.id AS id_1, t0.label AS label_2, t0.external_url AS external_url_3, t0.target AS target_4, t0.position AS position_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8, t0.menu_id AS menu_id_9, t0.url_alias_id AS url_alias_id_10 FROM menu_link t0 WHERE t0.url_alias_id = ? ORDER BY t0.id ASC LIMIT 1
Parameters:
[
  8819
]
3.25 ms
(0.67%)
2
SELECT t0.id AS id_1, t0.title AS title_2, t0.title_h1 AS title_h1_3, t0.body AS body_4, t0.image AS image_5, t0.show_header_image AS show_header_image_6, t0.layout AS layout_7, t0.pinned AS pinned_8, t0.created_at AS created_at_9, t0.published_at AS published_at_10, t0.updated_at AS updated_at_11, t0.published AS published_12, t0.archived AS archived_13, t0.exclude_from_search AS exclude_from_search_14, t0.seo_title AS seo_title_15, t0.seo_description AS seo_description_16, t0.seo_keywords AS seo_keywords_17, t0.seo_canonical AS seo_canonical_18, t0.seo_key AS seo_key_19, t0.seo_robots AS seo_robots_20, t0.seo_sitemap AS seo_sitemap_21 FROM content t0 WHERE t0.title = ? AND t0.published = ? LIMIT 1
Parameters:
[
  "Politique de Cookies"
  1
]
2.87 ms
(0.59%)
6
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.width AS width_4, t0.height AS height_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM image_style t0 WHERE t0.id = ?
Parameters:
[
  104
]
2.26 ms
(0.46%)
3
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3 FROM menu t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "topbar"
]
2.00 ms
(0.41%)
4
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:
[
  7385
]
1.63 ms
(0.33%)
1
SELECT t0.id AS id_1, t0.old_path AS old_path_2, t0.target_url AS target_url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.target_alias_id AS target_alias_id_6 FROM url_redirect t0 WHERE t0.old_path = ? LIMIT 1
Parameters:
[
  "destinations/pays/japon"
]
1.05 ms
(0.22%)
1
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.title_h1 AS title_h1_4, t0.period AS period_5, t0.time_difference AS time_difference_6, t0.currency AS currency_7, t0.formalities AS formalities_8, t0.good_to_know AS good_to_know_9, t0.body AS body_10, t0.intro AS intro_11, t0.image_content AS image_content_12, t0.image AS image_13, t0.main_menu AS main_menu_14, t0.favorite AS favorite_15, t0.active AS active_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.seo_title AS seo_title_19, t0.seo_description AS seo_description_20, t0.seo_keywords AS seo_keywords_21, t0.seo_canonical AS seo_canonical_22, t0.seo_key AS seo_key_23, t0.seo_robots AS seo_robots_24, t0.seo_sitemap AS seo_sitemap_25 FROM region t0 INNER JOIN region_country ON t0.id = region_country.region_id WHERE region_country.country_id = ?
Parameters:
[
  308
]
0.91 ms
(0.19%)
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.path = ? LIMIT 1
Parameters:
[
  "destinations/pays/japon"
]
0.54 ms
(0.11%)
1
SELECT t0.id AS id_1, t0.date_start AS date_start_2, t0.date_end AS date_end_3, t0.length AS length_4, t0.price AS price_5, t0.price_full AS price_full_6, t0.price_type AS price_type_7, t0.promo_price AS promo_price_8, t0.available AS available_9, t0.length_unit AS length_unit_10, t0.seat_code AS seat_code_11, t0.transport_code AS transport_code_12, t0.imported_at AS imported_at_13, t0.travel_offer_id AS travel_offer_id_14 FROM price_entry t0 WHERE t0.travel_offer_id = ?
Parameters:
[
  2146
]
0.52 ms
(0.11%)
1
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.title_h1 AS title_h1_4, t0.body AS body_5, t0.intro AS intro_6, t0.image_content AS image_content_7, t0.image AS image_8, t0.main_menu AS main_menu_9, t0.active AS active_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.position AS position_13, t0.seo_title AS seo_title_14, t0.seo_description AS seo_description_15, t0.seo_keywords AS seo_keywords_16, t0.seo_canonical AS seo_canonical_17, t0.seo_key AS seo_key_18, t0.seo_robots AS seo_robots_19, t0.seo_sitemap AS seo_sitemap_20 FROM continent t0 WHERE t0.id = ?
Parameters:
[
  46
]
0.45 ms
(0.09%)
1
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.title_h1 AS title_h1_4, t0.body AS body_5, t0.intro AS intro_6, t0.image_content AS image_content_7, t0.image AS image_8, t0.main_menu AS main_menu_9, t0.active AS active_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.position AS position_13, t0.seo_title AS seo_title_14, t0.seo_description AS seo_description_15, t0.seo_keywords AS seo_keywords_16, t0.seo_canonical AS seo_canonical_17, t0.seo_key AS seo_key_18, t0.seo_robots AS seo_robots_19, t0.seo_sitemap AS seo_sitemap_20, t0.continent_id AS continent_id_21 FROM country t0 WHERE t0.id = ?
Parameters:
[
  308
]
0.24 ms
(0.05%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.fallback_image_style_id AS fallback_image_style_id_6 FROM responsive_image_style t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "header-full-width"
]
0.20 ms
(0.04%)
1
SELECT t0.id AS id_1, t0.multiplier AS multiplier_2, t0.responsive_image_style_id AS responsive_image_style_id_3, t0.breakpoint_id AS breakpoint_id_4, t0.image_style_id AS image_style_id_5 FROM responsive_image_style_mapping t0 WHERE t0.responsive_image_style_id = ?
Parameters:
[
  22
]

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\MenuLink 57
App\Entity\UrlAlias 37
App\Entity\Travel\TravelImage 7
App\Entity\ImageStyle 7
App\Entity\ResponsiveImageStyleMapping 6
App\Entity\TravelDescription 4
App\Entity\Breakpoint 4
App\Entity\Menu 3
App\Entity\Content 2
App\Entity\Destination\Country 1
App\Entity\Destination\Continent 1
App\Entity\Destination\Region 1
App\Entity\Imported\TravelOffer 1
App\Entity\ResponsiveImageStyle 1

Entities Mapping