Symfony Profiler

[
  "route" => "url_alias_resolve"
  "route_parameters" => [
    "_route" => "url_alias_resolve"
    "path" => "concerts-spectacles"
    "_controller" => "App\Controller\UrlAliasController"
  ]
  "request_uri" => "https://www.leroy.goconcept8.be/concerts-spectacles?page=1"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "authenticators" => 2
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "localhost"
    "port" => 3350
    "user" => "leroy_symfony"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "leroy_symfony"
    "serverVersion" => "mariadb-10.3.39"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.old_path AS old_path_2, t0.target_url AS target_url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.target_alias_id AS target_alias_id_6 FROM url_redirect t0 WHERE t0.old_path = ? LIMIT 1"
  "params" => [
    1 => "concerts-spectacles"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#940
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.path AS path_3, t0.entity_type AS entity_type_4, t0.entity_id AS entity_id_5, t0.route_name AS route_name_6, t0.pathauto AS pathauto_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.parent_id AS parent_id_10 FROM url_alias t0 WHERE t0.path = ? LIMIT 1"
  "params" => [
    1 => "concerts-spectacles"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#940
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.title_h1 AS title_h1_3, t0.image AS image_4, t0.content AS content_5, t0.published AS published_6, t0.archived AS archived_7, t0.filter_calendar AS filter_calendar_8, t0.on_homepage AS on_homepage_9, t0.highlighted AS highlighted_10, t0.promoted AS promoted_11, t0.print_tab AS print_tab_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_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 thematique t0 WHERE t0.id = ?"
  "params" => [
    1 => 527
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "thematique"
    2 => 527
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#940
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "thematique"
    2 => 527
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#940
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 7996
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => """
    SELECT COUNT(*) FROM (\n
        SELECT ROW_NUMBER() OVER (\n
            PARTITION BY COALESCE(td.variant_group_id, td.id)\n
            ORDER BY td.canonical DESC, td.id ASC\n
        ) AS rn\n
        FROM travel_description td\n
        WHERE td.published = 1 AND (\n
        (td.offer_type = 'unique' AND td.unique_price > 0)\n
        OR EXISTS (\n
            SELECT 1 FROM travel_offer o\n
            INNER JOIN price_entry pe ON pe.travel_offer_id = o.id\n
            WHERE o.code = td.offer_code AND (\n
        (pe.price_type != 'transport' AND pe.price_full > 0)\n
        OR (\n
            pe.price_type = 'transport' AND pe.price_full > 0\n
            AND NOT EXISTS (\n
                SELECT 1 FROM price_entry pe2\n
                WHERE pe2.travel_offer_id = pe.travel_offer_id\n
                    AND pe2.price_type != 'transport' AND pe2.price_full > 0\n
            )\n
        )\n
    )\n
        )\n
    ) AND EXISTS (SELECT 1 FROM travel_thematique tt WHERE tt.travel_description_id = td.id AND tt.thematique_id = ?)\n
    ) collapsed\n
    WHERE collapsed.rn = 1
    """
  "params" => [
    1 => 527
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => """
    SELECT collapsed.id FROM (\n
        SELECT\n
            td.id,\n
                        td.title,\n
                        ROW_NUMBER() OVER (\n
        PARTITION BY COALESCE(td.variant_group_id, td.id)\n
        ORDER BY td.canonical DESC, td.id ASC\n
    ) AS rn\n
        FROM travel_description td\n
        WHERE td.published = 1 AND (\n
        (td.offer_type = 'unique' AND td.unique_price > 0)\n
        OR EXISTS (\n
            SELECT 1 FROM travel_offer o\n
            INNER JOIN price_entry pe ON pe.travel_offer_id = o.id\n
            WHERE o.code = td.offer_code AND (\n
        (pe.price_type != 'transport' AND pe.price_full > 0)\n
        OR (\n
            pe.price_type = 'transport' AND pe.price_full > 0\n
            AND NOT EXISTS (\n
                SELECT 1 FROM price_entry pe2\n
                WHERE pe2.travel_offer_id = pe.travel_offer_id\n
                    AND pe2.price_type != 'transport' AND pe2.price_full > 0\n
            )\n
        )\n
    )\n
        )\n
    ) AND EXISTS (SELECT 1 FROM travel_thematique tt WHERE tt.travel_description_id = td.id AND tt.thematique_id = ?)\n
    ) collapsed\n
    WHERE collapsed.rn = 1\n
    ORDER BY collapsed.title ASC\n
    LIMIT ? OFFSET ?
    """
  "params" => [
    1 => 527
    2 => 24
    3 => 0
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#942}
    3 => Doctrine\DBAL\ParameterType {#942}
  ]
]

[
  "sql" => "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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 7347
    2 => 7730
    3 => 7639
    4 => 7815
    5 => 7668
    6 => 7467
    7 => 7930
    8 => 7382
    9 => 8109
    10 => 7993
    11 => 7441
    12 => 7931
    13 => 7986
    14 => 7369
    15 => 7976
    16 => 7944
    17 => 7358
    18 => 7935
    19 => 7996
    20 => 8048
    21 => 7795
    22 => 7833
    23 => 7577
    24 => 7988
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#942}
    3 => Doctrine\DBAL\ParameterType {#942}
    4 => Doctrine\DBAL\ParameterType {#942}
    5 => Doctrine\DBAL\ParameterType {#942}
    6 => Doctrine\DBAL\ParameterType {#942}
    7 => Doctrine\DBAL\ParameterType {#942}
    8 => Doctrine\DBAL\ParameterType {#942}
    9 => Doctrine\DBAL\ParameterType {#942}
    10 => Doctrine\DBAL\ParameterType {#942}
    11 => Doctrine\DBAL\ParameterType {#942}
    12 => Doctrine\DBAL\ParameterType {#942}
    13 => Doctrine\DBAL\ParameterType {#942}
    14 => Doctrine\DBAL\ParameterType {#942}
    15 => Doctrine\DBAL\ParameterType {#942}
    16 => Doctrine\DBAL\ParameterType {#942}
    17 => Doctrine\DBAL\ParameterType {#942}
    18 => Doctrine\DBAL\ParameterType {#942}
    19 => Doctrine\DBAL\ParameterType {#942}
    20 => Doctrine\DBAL\ParameterType {#942}
    21 => Doctrine\DBAL\ParameterType {#942}
    22 => Doctrine\DBAL\ParameterType {#942}
    23 => Doctrine\DBAL\ParameterType {#942}
    24 => Doctrine\DBAL\ParameterType {#942}
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7347
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "travel-description"
    2 => 7347
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#940
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7358
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "travel-description"
    2 => 7358
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#940
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7369
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "travel-description"
    2 => 7369
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#940
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7382
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "travel-description"
    2 => 7382
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#940
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7441
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "travel-description"
    2 => 7441
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#940
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7467
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "travel-description"
    2 => 7467
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#940
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7577
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "travel-description"
    2 => 7577
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#940
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7639
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "travel-description"
    2 => 7639
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#940
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7668
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "travel-description"
    2 => 7668
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#940
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7730
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "travel-description"
    2 => 7730
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#940
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7795
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "travel-description"
    2 => 7795
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#940
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7815
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "travel-description"
    2 => 7815
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#940
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7833
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "travel-description"
    2 => 7833
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#940
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7930
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "travel-description"
    2 => 7930
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#940
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7931
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "travel-description"
    2 => 7931
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#940
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7935
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "travel-description"
    2 => 7935
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#940
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7944
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "travel-description"
    2 => 7944
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#940
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7976
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "travel-description"
    2 => 7976
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#940
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7986
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "travel-description"
    2 => 7986
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#940
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7988
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "travel-description"
    2 => 7988
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#940
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7993
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "travel-description"
    2 => 7993
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#940
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7996
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "travel-description"
    2 => 7996
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#940
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 8048
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "travel-description"
    2 => 8048
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#940
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 8109
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "travel-description"
    2 => 8109
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#940
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "BEANDRER"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#940
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 1786
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7347
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 7347
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "FRANGELE"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#940
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 1851
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7730
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 7730
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "BCALOGE2"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#940
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 1777
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7639
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 7639
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "BCHRISMA"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#940
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 1779
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7815
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 7815
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "BCWILLEM"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#940
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 1782
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7668
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 7668
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "BDISNONI"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#940
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 1784
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7467
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 7467
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "BEEROSRA"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#940
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 1790
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7930
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 7930
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "BPAGNY"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#940
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 1812
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7382
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 7382
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "FRPAGNY"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#940
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 1937
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 8109
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 8109
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "FRGDCOMA"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#940
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 1897
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7993
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 7993
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "BEGDCOMA"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#940
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 1792
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7441
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 7441
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "FRGALLHO"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#940
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 1895
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7931
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 7931
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#942
      +name: "INTEGER"
    }
  ]
]