Symfony Profiler

Query Metrics

279 Database Queries
20 Different statements
160.54 ms Query time
0 Invalid entities
326 Managed entities
Queries

Group similar statements
default connection


SELECT t0.id AS id_1, t0.title AS title_2, t0.body AS body_3, t0.cta_label AS cta_label_4, t0.external_url AS external_url_5, t0.image AS image_6, t0.mobile_image AS mobile_image_7, t0.slot AS slot_8, t0.published AS published_9, t0.archived AS archived_10, t0.position AS position_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.url_alias_id AS url_alias_id_14 FROM block_content t0 WHERE t0.slot = ? AND t0.published = ? AND t0.archived = ? LIMIT 1
SELECT t0.id AS id_1, t0.title AS title_2, t0.body AS body_3, t0.cta_label AS cta_label_4, t0.external_url AS external_url_5, t0.image AS image_6, t0.mobile_image AS mobile_image_7, t0.slot AS slot_8, t0.published AS published_9, t0.archived AS archived_10, t0.position AS position_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.url_alias_id AS url_alias_id_14 FROM block_content t0 WHERE t0.slot = ? AND t0.published = ? AND t0.archived = ? LIMIT 1
SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.title_h1 AS title_h1_2, t0_.image AS image_3, t0_.content AS content_4, t0_.published AS published_5, t0_.archived AS archived_6, t0_.filter_calendar AS filter_calendar_7, t0_.on_homepage AS on_homepage_8, t0_.highlighted AS highlighted_9, t0_.promoted AS promoted_10, t0_.print_tab AS print_tab_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 FROM thematique t0_ WHERE t0_.on_homepage = 1 AND t0_.published = 1 AND t0_.archived = 0 ORDER BY t0_.highlighted DESC, t0_.id ASC LIMIT 7
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
SELECT t0.id AS id_1, t0.name AS name_2, t0.date AS date_3, t0.location AS location_4, t0.content AS content_5, t0.image AS image_6, t0.background AS background_7, t0.published AS published_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM testimonial t0 WHERE t0.published = ?
SELECT COUNT(*) FROM (
    SELECT ROW_NUMBER() OVER (
        PARTITION BY COALESCE(td.variant_group_id, td.id)
        ORDER BY td.canonical DESC, td.id ASC
    ) AS rn
    FROM travel_description td
    WHERE td.published = 1 AND (
    (td.offer_type = 'unique' AND td.unique_price > 0)
    OR EXISTS (
        SELECT 1 FROM travel_offer o
        INNER JOIN price_entry pe ON pe.travel_offer_id = o.id
        WHERE o.code = td.offer_code AND (
    (pe.price_type != 'transport' AND pe.price_full > 0)
    OR (
        pe.price_type = 'transport' AND pe.price_full > 0
        AND NOT EXISTS (
            SELECT 1 FROM price_entry pe2
            WHERE pe2.travel_offer_id = pe.travel_offer_id
                AND pe2.price_type != 'transport' AND pe2.price_full > 0
        )
    )
)
    )
)
) collapsed
WHERE collapsed.rn = 1
SELECT collapsed.id FROM (
    SELECT
        td.id,
                    td.title,
                    ROW_NUMBER() OVER (
    PARTITION BY COALESCE(td.variant_group_id, td.id)
    ORDER BY td.canonical DESC, td.id ASC
) AS rn
    FROM travel_description td
    WHERE td.published = 1 AND (
    (td.offer_type = 'unique' AND td.unique_price > 0)
    OR EXISTS (
        SELECT 1 FROM travel_offer o
        INNER JOIN price_entry pe ON pe.travel_offer_id = o.id
        WHERE o.code = td.offer_code AND (
    (pe.price_type != 'transport' AND pe.price_full > 0)
    OR (
        pe.price_type = 'transport' AND pe.price_full > 0
        AND NOT EXISTS (
            SELECT 1 FROM price_entry pe2
            WHERE pe2.travel_offer_id = pe.travel_offer_id
                AND pe2.price_type != 'transport' AND pe2.price_full > 0
        )
    )
)
    )
)
) collapsed
WHERE collapsed.rn = 1
ORDER BY collapsed.title ASC
LIMIT ? OFFSET ?
SELECT t0_.id AS id_0, t0_.offer_code AS offer_code_1, t0_.offer_type AS offer_type_2, t0_.unique_price AS unique_price_3, t0_.unique_city AS unique_city_4, t0_.unique_description AS unique_description_5, t0_.unique_division AS unique_division_6, t0_.variant_label AS variant_label_7, t0_.canonical AS canonical_8, t0_.title AS title_9, t0_.teaser AS teaser_10, t0_.description AS description_11, t0_.intro AS intro_12, t0_.chapeau1 AS chapeau1_13, t0_.chapeau2 AS chapeau2_14, t0_.qualite_leo AS qualite_leo_15, t0_.entree_site AS entree_site_16, t0_.price_comment AS price_comment_17, t0_.gifts AS gifts_18, t0_.good_to_know AS good_to_know_19, t0_.important_info AS important_info_20, t0_.duration AS duration_21, t0_.duration_only_on_web AS duration_only_on_web_22, t0_.minimum_length AS minimum_length_23, t0_.is_stay AS is_stay_24, t0_.published AS published_25, t0_.special_offer_enabled AS special_offer_enabled_26, t0_.special_offer_url AS special_offer_url_27, t0_.not_in_brochure AS not_in_brochure_28, t0_.brochure_page AS brochure_page_29, t0_.brochure_column AS brochure_column_30, t0_.print_title AS print_title_31, t0_.print_intro AS print_intro_32, t0_.print_schedule AS print_schedule_33, t0_.print_starting_price AS print_starting_price_34, t0_.print_price_notes AS print_price_notes_35, t0_.print_date AS print_date_36, t0_.created_at AS created_at_37, t0_.updated_at AS updated_at_38, t0_.stay_services AS stay_services_39, t0_.stay_room AS stay_room_40, t0_.stay_catering AS stay_catering_41, t0_.stay_animation AS stay_animation_42, t0_.eco_impact_formula AS eco_impact_formula_43, t0_.eco_impact_type AS eco_impact_type_44, t0_.eco_impact_distance AS eco_impact_distance_45, t0_.eco_impact_emissions AS eco_impact_emissions_46, t0_.eco_impact_contribution AS eco_impact_contribution_47, t0_.seo_title AS seo_title_48, t0_.seo_description AS seo_description_49, t0_.seo_keywords AS seo_keywords_50, t0_.seo_canonical AS seo_canonical_51, t0_.seo_key AS seo_key_52, t0_.seo_robots AS seo_robots_53, t0_.seo_sitemap AS seo_sitemap_54, t0_.variant_group_id AS variant_group_id_55, t0_.type_id AS type_id_56, t0_.brochure_id AS brochure_id_57, t0_.print_thematique_id AS print_thematique_id_58 FROM travel_description t0_ WHERE t0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
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 = ?
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
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 = ?
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
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 = ?
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
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 = ?
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
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 = ?
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
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 = ?
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
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 = ?
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
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 = ?
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
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 = ?
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
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 = ?
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
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 = ?
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
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 = ?
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
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 = ?
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
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 = ?
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
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 = ?
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
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 = ?
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
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 = ?
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
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 = ?
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
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 = ?
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
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 = ?
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
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 = ?
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
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 = ?
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
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 = ?
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
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 = ?
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
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
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 = ?
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 = ?
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 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
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 = ?
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 = ?
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 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
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 = ?
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 = ?
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 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
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 = ?
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 = ?
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 3
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 = ?
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 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
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 = ?
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 = ?
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 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
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 = ?
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 = ?
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 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
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 = ?
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 = ?
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 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
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 = ?
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 = ?
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 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
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 = ?
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 = ?
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 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
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 = ?
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 = ?
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 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
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 = ?
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 = ?
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 3
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 = ?
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 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
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 = ?
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 = ?
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 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
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 = ?
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 = ?
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 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
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 = ?
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 = ?
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 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
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 = ?
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 = ?
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 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
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 = ?
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 = ?
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 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
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 = ?
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 = ?
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 3
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 = ?
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 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
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 = ?
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 = ?
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 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
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 = ?
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 = ?
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 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
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 = ?
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 = ?
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 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
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 = ?
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 = ?
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 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
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
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
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
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
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 = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3 FROM menu t0 WHERE t0.name = ? LIMIT 1
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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
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
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
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
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
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
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
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
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
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
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
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
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
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3 FROM menu t0 WHERE t0.name = ? LIMIT 1
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 = ?
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
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
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
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
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 = ?
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
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
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
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\Travel\TravelImage	88
App\Entity\UrlAlias	60
App\Entity\Imported\PriceEntry	58
App\Entity\MenuLink	57
App\Entity\TravelDescription	24
App\Entity\Imported\TravelOffer	21
App\Entity\Thematique	7
App\Entity\Menu	3
App\Entity\BlockContent	2
App\Entity\Testimonial	2
App\Entity\ImageStyle	2
App\Entity\Content	2
Entities Mapping

Class	Mapping errors
App\Entity\BlockContent	No errors.
App\Entity\UrlAlias	No errors.
App\Entity\Embeddable\Seo	No errors.
App\Entity\Thematique	No errors.
App\Entity\MenuLink	No errors.
App\Entity\Menu	No errors.
App\Entity\Testimonial	No errors.
App\Entity\Embeddable\Stay	No errors.
App\Entity\Embeddable\EcoImpact	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\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\Imported\TravelOffer	No errors.
App\Entity\Imported\PriceEntry	No errors.
App\Entity\Imported\BoardGroup	No errors.
App\Entity\TravelTerm	No errors.
App\Entity\TravelTaxonomy	No errors.
App\Entity\Logo	No errors.
App\Entity\ImageStyle	No errors.
App\Entity\Content\ContentGallery	No errors.
App\Entity\Content\ContentTab	No errors.
App\Entity\Structural\ContentDisplaySlot	No errors.
Symfony Profiler

GET https://www.leroy.goconcept8.be/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping
