GET https://dev.thelliervoyages.com/destination/croisiere-en-antarctique

Query Metrics

116 Database Queries
29 Different statements
13.61 ms Query time
3 Invalid entities
188 Managed entities

Queries

Group similar statements

default connection

# Time Info
1 0.33 ms
SELECT t0.id AS id_1, t0.is_activate AS is_activate_2, t0.ips AS ips_3, t0.message AS message_4 FROM maintenance t0 LIMIT 1
Parameters:
[]
2 0.13 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = ? LIMIT 1
Parameters:
[
  "LOGO_PATH"
]
3 0.34 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.meta_description AS meta_description_4, t0.meta_keywords AS meta_keywords_5, t0.og_title AS og_title_6, t0.twitter_card AS twitter_card_7, t0.page_type AS page_type_8, t0.og_image_id AS og_image_id_9, t0.twitter_image_id AS twitter_image_id_10 FROM seo_meta_data t0 WHERE t0.url IN (?) AND t0.page_type = ? LIMIT 1
Parameters:
[
  "croisiere-en-antarctique"
  "destination"
]
4 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.subtitle AS subtitle_4, t0.cygest_code AS cygest_code_5, t0.cygest_name AS cygest_name_6, t0.days AS days_7, t0.nights AS nights_8, t0.soon AS soon_9, t0.is_health_situation AS is_health_situation_10, t0.description_introduction AS description_introduction_11, t0.description_resume AS description_resume_12, t0.description_body AS description_body_13, t0.camping_car_circuit AS camping_car_circuit_14, t0.average_distance AS average_distance_15, t0.days_without_driving AS days_without_driving_16, t0.youtube AS youtube_17, t0.our_prices_include AS our_prices_include_18, t0.our_prices_does_not_include AS our_prices_does_not_include_19, t0.rates_details AS rates_details_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.enabled AS enabled_23, t0.is_archive AS is_archive_24, t0.we_like AS we_like_25, t0.scale AS scale_26, t0.is_upon_request AS is_upon_request_27, t0.is_new AS is_new_28, t0.is_pre_registration_allowed AS is_pre_registration_allowed_29, t0.reservation_limit AS reservation_limit_30, t0.is_animal_forbidden AS is_animal_forbidden_31, t0.author_id AS author_id_32, t33.id AS id_34, t33.path AS path_35, t33.alt AS alt_36, t33.title AS title_37, t33.destination_id AS destination_id_38, t39.id AS id_40, t39.path AS path_41, t39.alt AS alt_42, t39.title AS title_43, t39.destination_id AS destination_id_44, t0.type_id AS type_id_45, t0.seo_id AS seo_id_46 FROM destination t0 LEFT JOIN destination_map t33 ON t33.destination_id = t0.id LEFT JOIN destination_hero t39 ON t39.destination_id = t0.id WHERE t0.seo_id = ? LIMIT 1
Parameters:
[
  949
]
5 0.15 ms
SELECT t1.id AS id_2, t1.path AS path_3, t1.name AS name_4, t1.mime_type AS mime_type_5, t1.created_at AS created_at_6, t1.updated_at AS updated_at_7, t0.destination_id AS destination_id_8, t1.discr FROM destination_hero_video t0 INNER JOIN video t1 ON t0.id = t1.id WHERE t0.destination_id = ?
Parameters:
[
  210
]
6 0.13 ms
SELECT t1.id AS id_2, t1.path AS path_3, t1.name AS name_4, t1.mime_type AS mime_type_5, t1.created_at AS created_at_6, t1.updated_at AS updated_at_7, t0.destination_id AS destination_id_8, t1.discr FROM destination_video t0 INNER JOIN video t1 ON t0.id = t1.id WHERE t0.destination_id = ?
Parameters:
[
  210
]
7 0.11 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.position AS position_4, t0.destination_id AS destination_id_5 FROM destination_qn_a t0 WHERE t0.destination_id = ? ORDER BY t0.position ASC
Parameters:
[
  210
]
8 0.12 ms
SELECT t0.id AS id_1, t0.id_crypt AS id_crypt_2, t0.name AS name_3, t0.starting_point AS starting_point_4, t0.days AS days_5, t0.is_complete AS is_complete_6, t0.is_last_spot AS is_last_spot_7, t0.guides AS guides_8, t0.date_from AS date_from_9, t0.start_date AS start_date_10, t0.date_to AS date_to_11, t0.registration_deadline AS registration_deadline_12, t0.formalities AS formalities_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.enabled AS enabled_16, t0.is_promoted AS is_promoted_17, t0.is_pre_registered_notified AS is_pre_registered_notified_18, t0.destination_id AS destination_id_19 FROM travel t0 WHERE t0.destination_id = ? ORDER BY t0.date_from DESC
Parameters:
[
  210
]
9 0.46 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.text AS text_3, t0.title AS title_4, t0.destination_id AS destination_id_5 FROM destination_day t0 WHERE t0.destination_id = ? ORDER BY t0.position ASC
Parameters:
[
  210
]
10 0.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.is_free AS is_free_4, t0.travel_id AS travel_id_5 FROM rate t0 WHERE t0.travel_id = ?
Parameters:
[
  32
]
11 0.10 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.enabled AS enabled_4, t0.slug AS slug_5, t0.is_camping_car_required AS is_camping_car_required_6, t0.pre_registration_amount AS pre_registration_amount_7, t0.icon_id AS icon_id_8 FROM destination_type t0 WHERE t0.id = ?
Parameters:
[
  4
]
12 0.10 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.enabled AS enabled_4, t0.slug AS slug_5, t0.is_camping_car_required AS is_camping_car_required_6, t0.pre_registration_amount AS pre_registration_amount_7, t0.icon_id AS icon_id_8 FROM destination_type t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "croisiere-en-antarctique"
]
13 0.24 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.meta_description AS meta_description_4, t0.meta_keywords AS meta_keywords_5, t0.og_title AS og_title_6, t0.twitter_card AS twitter_card_7, t0.page_type AS page_type_8, t0.og_image_id AS og_image_id_9, t0.twitter_image_id AS twitter_image_id_10 FROM seo_meta_data t0 WHERE t0.url = ? LIMIT 1
Parameters:
[
  "croisiere-en-antarctique"
]
14 0.18 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.subtitle AS subtitle_4, t0.cygest_code AS cygest_code_5, t0.cygest_name AS cygest_name_6, t0.days AS days_7, t0.nights AS nights_8, t0.soon AS soon_9, t0.is_health_situation AS is_health_situation_10, t0.description_introduction AS description_introduction_11, t0.description_resume AS description_resume_12, t0.description_body AS description_body_13, t0.camping_car_circuit AS camping_car_circuit_14, t0.average_distance AS average_distance_15, t0.days_without_driving AS days_without_driving_16, t0.youtube AS youtube_17, t0.our_prices_include AS our_prices_include_18, t0.our_prices_does_not_include AS our_prices_does_not_include_19, t0.rates_details AS rates_details_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.enabled AS enabled_23, t0.is_archive AS is_archive_24, t0.we_like AS we_like_25, t0.scale AS scale_26, t0.is_upon_request AS is_upon_request_27, t0.is_new AS is_new_28, t0.is_pre_registration_allowed AS is_pre_registration_allowed_29, t0.reservation_limit AS reservation_limit_30, t0.is_animal_forbidden AS is_animal_forbidden_31, t0.author_id AS author_id_32, t33.id AS id_34, t33.path AS path_35, t33.alt AS alt_36, t33.title AS title_37, t33.destination_id AS destination_id_38, t39.id AS id_40, t39.path AS path_41, t39.alt AS alt_42, t39.title AS title_43, t39.destination_id AS destination_id_44, t0.type_id AS type_id_45, t0.seo_id AS seo_id_46 FROM destination t0 LEFT JOIN destination_map t33 ON t33.destination_id = t0.id LEFT JOIN destination_hero t39 ON t39.destination_id = t0.id WHERE t0.seo_id = ? LIMIT 1
Parameters:
[
  949
]
15 0.09 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = ? LIMIT 1
Parameters:
[
  "FAVICON_PATH"
]
16 0.08 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = ? LIMIT 1
Parameters:
[
  "ICON_MOBILE_PATH"
]
17 0.09 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = ? LIMIT 1
Parameters:
[
  "GOOGLE_TAG_MANAGER"
]
18 0.12 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = ? LIMIT 1
Parameters:
[
  "CONTACT_PHONE"
]
19 0.09 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = ? LIMIT 1
Parameters:
[
  "CONTACT_MAIL"
]
20 0.10 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = ? LIMIT 1
Parameters:
[
  "CONTACT_ADDRESS"
]
21 0.09 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = ? LIMIT 1
Parameters:
[
  "CONTACT_ZIP_CODE"
]
22 0.08 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = ? LIMIT 1
Parameters:
[
  "CONTACT_CITY"
]
23 0.09 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = ? LIMIT 1
Parameters:
[
  "CONTACT_OPENING"
]
24 0.09 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = ? LIMIT 1
Parameters:
[
  "CONTACT_LONGITUDE"
]
25 0.09 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = ? LIMIT 1
Parameters:
[
  "CONTACT_LATITUDE"
]
26 0.13 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.type AS type_3, t0.position AS position_4, t0.enabled AS enabled_5 FROM social_network t0 WHERE t0.enabled = ?
Parameters:
[
  1
]
27 0.13 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = ? LIMIT 1
Parameters:
[
  "BROCHURE_FILE_ID"
]
28 0.14 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.archived AS archived_5, t0.thumbnail AS thumbnail_6, t0.filename AS filename_7 FROM file t0 WHERE t0.id = ?
Parameters:
[
  "13"
]
29 0.36 ms
SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.type AS type_2, m0_.url AS url_3, m0_.route AS route_4, m0_.position AS position_5, m0_.enabled AS enabled_6, m0_.updated_at AS updated_at_7, m0_.created_at AS created_at_8, m0_.path AS path_9, m0_.has_link AS has_link_10, m1_.id AS id_11, m1_.title AS title_12, m1_.type AS type_13, m1_.url AS url_14, m1_.route AS route_15, m1_.position AS position_16, m1_.enabled AS enabled_17, m1_.updated_at AS updated_at_18, m1_.created_at AS created_at_19, m1_.path AS path_20, m1_.has_link AS has_link_21, m0_.parent_id AS parent_id_22, m0_.menu_id AS menu_id_23, m1_.parent_id AS parent_id_24, m1_.menu_id AS menu_id_25 FROM menu_item m0_ LEFT JOIN menu_item m1_ ON m0_.id = m1_.parent_id LEFT JOIN menu m2_ ON m0_.menu_id = m2_.id LEFT JOIN menu_type m3_ ON m2_.type_id = m3_.id WHERE m0_.parent_id IS NULL AND m0_.enabled = 1 AND m3_.name LIKE '%MENU%' ORDER BY m0_.position ASC, m1_.position ASC
Parameters:
[]
30 0.12 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = ? LIMIT 1
Parameters:
[
  "LOGO_PATH"
]
31 0.11 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = ? LIMIT 1
Parameters:
[
  "LOGO2X_PATH"
]
32 0.10 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = ? LIMIT 1
Parameters:
[
  "LOGO_PATH"
]
33 0.10 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = ? LIMIT 1
Parameters:
[
  "LOGO2X_PATH"
]
34 0.09 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = ? LIMIT 1
Parameters:
[
  "LOGO_PATH"
]
35 0.09 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = ? LIMIT 1
Parameters:
[
  "LOGO_PATH"
]
36 0.09 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = ? LIMIT 1
Parameters:
[
  "LOGO2X_PATH"
]
37 0.13 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.url AS url_4, t0.route AS route_5, t0.position AS position_6, t0.enabled AS enabled_7, t0.updated_at AS updated_at_8, t0.created_at AS created_at_9, t0.path AS path_10, t0.has_link AS has_link_11, t0.parent_id AS parent_id_12, t0.menu_id AS menu_id_13 FROM menu_item t0 WHERE t0.parent_id = ?
Parameters:
[
  37
]
38 0.12 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.url AS url_4, t0.route AS route_5, t0.position AS position_6, t0.enabled AS enabled_7, t0.updated_at AS updated_at_8, t0.created_at AS created_at_9, t0.path AS path_10, t0.has_link AS has_link_11, t0.parent_id AS parent_id_12, t0.menu_id AS menu_id_13 FROM menu_item t0 WHERE t0.parent_id = ?
Parameters:
[
  38
]
39 0.11 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.url AS url_4, t0.route AS route_5, t0.position AS position_6, t0.enabled AS enabled_7, t0.updated_at AS updated_at_8, t0.created_at AS created_at_9, t0.path AS path_10, t0.has_link AS has_link_11, t0.parent_id AS parent_id_12, t0.menu_id AS menu_id_13 FROM menu_item t0 WHERE t0.parent_id = ?
Parameters:
[
  39
]
40 0.10 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.url AS url_4, t0.route AS route_5, t0.position AS position_6, t0.enabled AS enabled_7, t0.updated_at AS updated_at_8, t0.created_at AS created_at_9, t0.path AS path_10, t0.has_link AS has_link_11, t0.parent_id AS parent_id_12, t0.menu_id AS menu_id_13 FROM menu_item t0 WHERE t0.parent_id = ?
Parameters:
[
  40
]
41 0.11 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.url AS url_4, t0.route AS route_5, t0.position AS position_6, t0.enabled AS enabled_7, t0.updated_at AS updated_at_8, t0.created_at AS created_at_9, t0.path AS path_10, t0.has_link AS has_link_11, t0.parent_id AS parent_id_12, t0.menu_id AS menu_id_13 FROM menu_item t0 WHERE t0.parent_id = ?
Parameters:
[
  41
]
42 0.11 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.url AS url_4, t0.route AS route_5, t0.position AS position_6, t0.enabled AS enabled_7, t0.updated_at AS updated_at_8, t0.created_at AS created_at_9, t0.path AS path_10, t0.has_link AS has_link_11, t0.parent_id AS parent_id_12, t0.menu_id AS menu_id_13 FROM menu_item t0 WHERE t0.parent_id = ?
Parameters:
[
  42
]
43 0.11 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.url AS url_4, t0.route AS route_5, t0.position AS position_6, t0.enabled AS enabled_7, t0.updated_at AS updated_at_8, t0.created_at AS created_at_9, t0.path AS path_10, t0.has_link AS has_link_11, t0.parent_id AS parent_id_12, t0.menu_id AS menu_id_13 FROM menu_item t0 WHERE t0.parent_id = ?
Parameters:
[
  43
]
44 0.09 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.url AS url_4, t0.route AS route_5, t0.position AS position_6, t0.enabled AS enabled_7, t0.updated_at AS updated_at_8, t0.created_at AS created_at_9, t0.path AS path_10, t0.has_link AS has_link_11, t0.parent_id AS parent_id_12, t0.menu_id AS menu_id_13 FROM menu_item t0 WHERE t0.parent_id = ?
Parameters:
[
  44
]
45 0.10 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.url AS url_4, t0.route AS route_5, t0.position AS position_6, t0.enabled AS enabled_7, t0.updated_at AS updated_at_8, t0.created_at AS created_at_9, t0.path AS path_10, t0.has_link AS has_link_11, t0.parent_id AS parent_id_12, t0.menu_id AS menu_id_13 FROM menu_item t0 WHERE t0.parent_id = ?
Parameters:
[
  45
]
46 0.12 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.url AS url_4, t0.route AS route_5, t0.position AS position_6, t0.enabled AS enabled_7, t0.updated_at AS updated_at_8, t0.created_at AS created_at_9, t0.path AS path_10, t0.has_link AS has_link_11, t0.parent_id AS parent_id_12, t0.menu_id AS menu_id_13 FROM menu_item t0 WHERE t0.parent_id = ?
Parameters:
[
  47
]
47 0.11 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.url AS url_4, t0.route AS route_5, t0.position AS position_6, t0.enabled AS enabled_7, t0.updated_at AS updated_at_8, t0.created_at AS created_at_9, t0.path AS path_10, t0.has_link AS has_link_11, t0.parent_id AS parent_id_12, t0.menu_id AS menu_id_13 FROM menu_item t0 WHERE t0.parent_id = ?
Parameters:
[
  48
]
48 0.11 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.url AS url_4, t0.route AS route_5, t0.position AS position_6, t0.enabled AS enabled_7, t0.updated_at AS updated_at_8, t0.created_at AS created_at_9, t0.path AS path_10, t0.has_link AS has_link_11, t0.parent_id AS parent_id_12, t0.menu_id AS menu_id_13 FROM menu_item t0 WHERE t0.parent_id = ?
Parameters:
[
  49
]
49 0.11 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.url AS url_4, t0.route AS route_5, t0.position AS position_6, t0.enabled AS enabled_7, t0.updated_at AS updated_at_8, t0.created_at AS created_at_9, t0.path AS path_10, t0.has_link AS has_link_11, t0.parent_id AS parent_id_12, t0.menu_id AS menu_id_13 FROM menu_item t0 WHERE t0.parent_id = ?
Parameters:
[
  50
]
50 0.10 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = ? LIMIT 1
Parameters:
[
  "QNA_CMS_ID"
]
51 0.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.enabled AS enabled_5, t0.content AS content_6, t0.seo_id AS seo_id_7 FROM cms t0 WHERE t0.id = ?
Parameters:
[
  "13"
]
52 0.12 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.meta_description AS meta_description_4, t0.meta_keywords AS meta_keywords_5, t0.og_title AS og_title_6, t0.twitter_card AS twitter_card_7, t0.page_type AS page_type_8, t0.og_image_id AS og_image_id_9, t0.twitter_image_id AS twitter_image_id_10 FROM seo_meta_data t0 WHERE t0.id = ?
Parameters:
[
  955
]
53 0.16 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.alt AS alt_3, t0.title AS title_4, t0.position AS position_5, t0.legend AS legend_6, t0.destination_id AS destination_id_7 FROM destination_image t0 WHERE t0.destination_id = ? ORDER BY t0.position ASC
Parameters:
[
  210
]
54 0.16 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.uid AS uid_3, t0.state AS state_4, t0.method AS method_5, t0.payed_at AS payed_at_6, t0.axepta_pay_id AS axepta_pay_id_7, t0.year AS year_8, t0.is_used AS is_used_9, t0.destination_id AS destination_id_10, t0.billing_id AS billing_id_11, t0.user_id AS user_id_12 FROM pre_registration t0 WHERE t0.destination_id = ? AND t0.year = ? AND t0.state IN (?, ?) AND t0.is_used = ?
Parameters:
[
  210
  2026
  "pending_approval"
  "paid"
  0
]
55 0.18 ms
SELECT t0.id AS id_1, t0.camping_car_length AS camping_car_length_2, t0.camping_car_height AS camping_car_height_3, t0.has_animal AS has_animal_4, t0.price AS price_5, t0.total_price AS total_price_6, t0.cygest_export_date AS cygest_export_date_7, t0.state AS state_8, t0.cygest_return AS cygest_return_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.coupon_code AS coupon_code_12, t0.coupon_amount AS coupon_amount_13, t0.uuid AS uuid_14, t0.old_options AS old_options_15, t0.pre_registration_amount AS pre_registration_amount_16, t0.pdf_destination AS pdf_destination_17, t0.authored_by_id AS authored_by_id_18, t0.travel_id AS travel_id_19, t0.billing_id AS billing_id_20 FROM reservation t0 WHERE t0.travel_id = ? AND t0.state IN (?, ?, ?)
Parameters:
[
  32
  "awaiting_down_payment"
  "partially_paid"
  "partially_paid"
]
56 0.14 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.name AS name_3, t0.position AS position_4, t0.destination_id AS destination_id_5 FROM destination_file t0 WHERE t0.destination_id = ? ORDER BY t0.position ASC
Parameters:
[
  210
]
57 0.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.icon_id AS icon_id_3 FROM pictogram t0 INNER JOIN destination_pictogram ON t0.id = destination_pictogram.pictogram_id WHERE destination_pictogram.destination_id = ?
Parameters:
[
  210
]
58 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.svg AS svg_3 FROM icon t0 WHERE t0.id = ?
Parameters:
[
  34
]
59 0.09 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.svg AS svg_3 FROM icon t0 WHERE t0.id = ?
Parameters:
[
  24
]
60 0.08 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.svg AS svg_3 FROM icon t0 WHERE t0.id = ?
Parameters:
[
  35
]
61 0.14 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.uid AS uid_3, t0.state AS state_4, t0.method AS method_5, t0.payed_at AS payed_at_6, t0.axepta_pay_id AS axepta_pay_id_7, t0.year AS year_8, t0.is_used AS is_used_9, t0.destination_id AS destination_id_10, t0.billing_id AS billing_id_11, t0.user_id AS user_id_12 FROM pre_registration t0 WHERE t0.destination_id = ? AND t0.year = ? AND t0.state IN (?, ?) AND t0.is_used = ?
Parameters:
[
  210
  2026
  "pending_approval"
  "paid"
  0
]
62 0.14 ms
SELECT t0.id AS id_1, t0.camping_car_length AS camping_car_length_2, t0.camping_car_height AS camping_car_height_3, t0.has_animal AS has_animal_4, t0.price AS price_5, t0.total_price AS total_price_6, t0.cygest_export_date AS cygest_export_date_7, t0.state AS state_8, t0.cygest_return AS cygest_return_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.coupon_code AS coupon_code_12, t0.coupon_amount AS coupon_amount_13, t0.uuid AS uuid_14, t0.old_options AS old_options_15, t0.pre_registration_amount AS pre_registration_amount_16, t0.pdf_destination AS pdf_destination_17, t0.authored_by_id AS authored_by_id_18, t0.travel_id AS travel_id_19, t0.billing_id AS billing_id_20 FROM reservation t0 WHERE t0.travel_id = ? AND t0.state IN (?, ?, ?)
Parameters:
[
  32
  "awaiting_down_payment"
  "partially_paid"
  "partially_paid"
]
63 0.11 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.svg AS svg_3 FROM icon t0 WHERE t0.id = ?
Parameters:
[
  15
]
64 0.13 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.uid AS uid_3, t0.state AS state_4, t0.method AS method_5, t0.payed_at AS payed_at_6, t0.axepta_pay_id AS axepta_pay_id_7, t0.year AS year_8, t0.is_used AS is_used_9, t0.destination_id AS destination_id_10, t0.billing_id AS billing_id_11, t0.user_id AS user_id_12 FROM pre_registration t0 WHERE t0.destination_id = ? AND t0.year = ? AND t0.state IN (?, ?) AND t0.is_used = ?
Parameters:
[
  210
  2027
  "pending_approval"
  "paid"
  0
]
65 0.16 ms
SELECT t0.id AS id_1, t0.id_cygest AS id_cygest_2, t0.name AS name_3, t0.price AS price_4, t0.type AS type_5, t0.travel_id AS travel_id_6 FROM option t0 WHERE t0.travel_id = ?
Parameters:
[
  32
]
66 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.subtitle AS subtitle_4, t0.cygest_code AS cygest_code_5, t0.cygest_name AS cygest_name_6, t0.days AS days_7, t0.nights AS nights_8, t0.soon AS soon_9, t0.is_health_situation AS is_health_situation_10, t0.description_introduction AS description_introduction_11, t0.description_resume AS description_resume_12, t0.description_body AS description_body_13, t0.camping_car_circuit AS camping_car_circuit_14, t0.average_distance AS average_distance_15, t0.days_without_driving AS days_without_driving_16, t0.youtube AS youtube_17, t0.our_prices_include AS our_prices_include_18, t0.our_prices_does_not_include AS our_prices_does_not_include_19, t0.rates_details AS rates_details_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.enabled AS enabled_23, t0.is_archive AS is_archive_24, t0.we_like AS we_like_25, t0.scale AS scale_26, t0.is_upon_request AS is_upon_request_27, t0.is_new AS is_new_28, t0.is_pre_registration_allowed AS is_pre_registration_allowed_29, t0.reservation_limit AS reservation_limit_30, t0.is_animal_forbidden AS is_animal_forbidden_31, t0.author_id AS author_id_32, t33.id AS id_34, t33.path AS path_35, t33.alt AS alt_36, t33.title AS title_37, t33.destination_id AS destination_id_38, t39.id AS id_40, t39.path AS path_41, t39.alt AS alt_42, t39.title AS title_43, t39.destination_id AS destination_id_44, t0.type_id AS type_id_45, t0.seo_id AS seo_id_46 FROM destination t0 LEFT JOIN destination_map t33 ON t33.destination_id = t0.id LEFT JOIN destination_hero t39 ON t39.destination_id = t0.id INNER JOIN destination_destination ON t0.id = destination_destination.destination_target WHERE destination_destination.destination_source = ?
Parameters:
[
  210
]
67 0.12 ms
SELECT t1.id AS id_2, t1.path AS path_3, t1.name AS name_4, t1.mime_type AS mime_type_5, t1.created_at AS created_at_6, t1.updated_at AS updated_at_7, t0.destination_id AS destination_id_8, t1.discr FROM destination_hero_video t0 INNER JOIN video t1 ON t0.id = t1.id WHERE t0.destination_id = ?
Parameters:
[
  82
]
68 0.09 ms
SELECT t1.id AS id_2, t1.path AS path_3, t1.name AS name_4, t1.mime_type AS mime_type_5, t1.created_at AS created_at_6, t1.updated_at AS updated_at_7, t0.destination_id AS destination_id_8, t1.discr FROM destination_video t0 INNER JOIN video t1 ON t0.id = t1.id WHERE t0.destination_id = ?
Parameters:
[
  82
]
69 0.08 ms
SELECT t1.id AS id_2, t1.path AS path_3, t1.name AS name_4, t1.mime_type AS mime_type_5, t1.created_at AS created_at_6, t1.updated_at AS updated_at_7, t0.destination_id AS destination_id_8, t1.discr FROM destination_hero_video t0 INNER JOIN video t1 ON t0.id = t1.id WHERE t0.destination_id = ?
Parameters:
[
  163
]
70 0.08 ms
SELECT t1.id AS id_2, t1.path AS path_3, t1.name AS name_4, t1.mime_type AS mime_type_5, t1.created_at AS created_at_6, t1.updated_at AS updated_at_7, t0.destination_id AS destination_id_8, t1.discr FROM destination_video t0 INNER JOIN video t1 ON t0.id = t1.id WHERE t0.destination_id = ?
Parameters:
[
  163
]
71 0.08 ms
SELECT t1.id AS id_2, t1.path AS path_3, t1.name AS name_4, t1.mime_type AS mime_type_5, t1.created_at AS created_at_6, t1.updated_at AS updated_at_7, t0.destination_id AS destination_id_8, t1.discr FROM destination_hero_video t0 INNER JOIN video t1 ON t0.id = t1.id WHERE t0.destination_id = ?
Parameters:
[
  196
]
72 0.07 ms
SELECT t1.id AS id_2, t1.path AS path_3, t1.name AS name_4, t1.mime_type AS mime_type_5, t1.created_at AS created_at_6, t1.updated_at AS updated_at_7, t0.destination_id AS destination_id_8, t1.discr FROM destination_video t0 INNER JOIN video t1 ON t0.id = t1.id WHERE t0.destination_id = ?
Parameters:
[
  196
]
73 0.08 ms
SELECT t1.id AS id_2, t1.path AS path_3, t1.name AS name_4, t1.mime_type AS mime_type_5, t1.created_at AS created_at_6, t1.updated_at AS updated_at_7, t0.destination_id AS destination_id_8, t1.discr FROM destination_hero_video t0 INNER JOIN video t1 ON t0.id = t1.id WHERE t0.destination_id = ?
Parameters:
[
  209
]
74 0.07 ms
SELECT t1.id AS id_2, t1.path AS path_3, t1.name AS name_4, t1.mime_type AS mime_type_5, t1.created_at AS created_at_6, t1.updated_at AS updated_at_7, t0.destination_id AS destination_id_8, t1.discr FROM destination_video t0 INNER JOIN video t1 ON t0.id = t1.id WHERE t0.destination_id = ?
Parameters:
[
  209
]
75 0.09 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.meta_description AS meta_description_4, t0.meta_keywords AS meta_keywords_5, t0.og_title AS og_title_6, t0.twitter_card AS twitter_card_7, t0.page_type AS page_type_8, t0.og_image_id AS og_image_id_9, t0.twitter_image_id AS twitter_image_id_10 FROM seo_meta_data t0 WHERE t0.id = ?
Parameters:
[
  818
]
76 0.13 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.alt AS alt_3, t0.title AS title_4, t0.position AS position_5, t0.legend AS legend_6, t0.destination_id AS destination_id_7 FROM destination_image t0 WHERE t0.destination_id = ? ORDER BY t0.position ASC
Parameters:
[
  82
]
77 0.14 ms
SELECT t0.id AS id_1, t0.id_crypt AS id_crypt_2, t0.name AS name_3, t0.starting_point AS starting_point_4, t0.days AS days_5, t0.is_complete AS is_complete_6, t0.is_last_spot AS is_last_spot_7, t0.guides AS guides_8, t0.date_from AS date_from_9, t0.start_date AS start_date_10, t0.date_to AS date_to_11, t0.registration_deadline AS registration_deadline_12, t0.formalities AS formalities_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.enabled AS enabled_16, t0.is_promoted AS is_promoted_17, t0.is_pre_registered_notified AS is_pre_registered_notified_18, t0.destination_id AS destination_id_19 FROM travel t0 WHERE t0.destination_id = ? ORDER BY t0.date_from DESC
Parameters:
[
  82
]
78 0.10 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.meta_description AS meta_description_4, t0.meta_keywords AS meta_keywords_5, t0.og_title AS og_title_6, t0.twitter_card AS twitter_card_7, t0.page_type AS page_type_8, t0.og_image_id AS og_image_id_9, t0.twitter_image_id AS twitter_image_id_10 FROM seo_meta_data t0 WHERE t0.id = ?
Parameters:
[
  898
]
79 0.12 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.alt AS alt_3, t0.title AS title_4, t0.position AS position_5, t0.legend AS legend_6, t0.destination_id AS destination_id_7 FROM destination_image t0 WHERE t0.destination_id = ? ORDER BY t0.position ASC
Parameters:
[
  163
]
80 0.14 ms
SELECT t0.id AS id_1, t0.id_crypt AS id_crypt_2, t0.name AS name_3, t0.starting_point AS starting_point_4, t0.days AS days_5, t0.is_complete AS is_complete_6, t0.is_last_spot AS is_last_spot_7, t0.guides AS guides_8, t0.date_from AS date_from_9, t0.start_date AS start_date_10, t0.date_to AS date_to_11, t0.registration_deadline AS registration_deadline_12, t0.formalities AS formalities_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.enabled AS enabled_16, t0.is_promoted AS is_promoted_17, t0.is_pre_registered_notified AS is_pre_registered_notified_18, t0.destination_id AS destination_id_19 FROM travel t0 WHERE t0.destination_id = ? ORDER BY t0.date_from DESC
Parameters:
[
  163
]
81 0.10 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.meta_description AS meta_description_4, t0.meta_keywords AS meta_keywords_5, t0.og_title AS og_title_6, t0.twitter_card AS twitter_card_7, t0.page_type AS page_type_8, t0.og_image_id AS og_image_id_9, t0.twitter_image_id AS twitter_image_id_10 FROM seo_meta_data t0 WHERE t0.id = ?
Parameters:
[
  947
]
82 0.12 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.alt AS alt_3, t0.title AS title_4, t0.position AS position_5, t0.legend AS legend_6, t0.destination_id AS destination_id_7 FROM destination_image t0 WHERE t0.destination_id = ? ORDER BY t0.position ASC
Parameters:
[
  196
]
83 0.11 ms
SELECT t0.id AS id_1, t0.id_crypt AS id_crypt_2, t0.name AS name_3, t0.starting_point AS starting_point_4, t0.days AS days_5, t0.is_complete AS is_complete_6, t0.is_last_spot AS is_last_spot_7, t0.guides AS guides_8, t0.date_from AS date_from_9, t0.start_date AS start_date_10, t0.date_to AS date_to_11, t0.registration_deadline AS registration_deadline_12, t0.formalities AS formalities_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.enabled AS enabled_16, t0.is_promoted AS is_promoted_17, t0.is_pre_registered_notified AS is_pre_registered_notified_18, t0.destination_id AS destination_id_19 FROM travel t0 WHERE t0.destination_id = ? ORDER BY t0.date_from DESC
Parameters:
[
  196
]
84 0.09 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.meta_description AS meta_description_4, t0.meta_keywords AS meta_keywords_5, t0.og_title AS og_title_6, t0.twitter_card AS twitter_card_7, t0.page_type AS page_type_8, t0.og_image_id AS og_image_id_9, t0.twitter_image_id AS twitter_image_id_10 FROM seo_meta_data t0 WHERE t0.id = ?
Parameters:
[
  948
]
85 0.10 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.alt AS alt_3, t0.title AS title_4, t0.position AS position_5, t0.legend AS legend_6, t0.destination_id AS destination_id_7 FROM destination_image t0 WHERE t0.destination_id = ? ORDER BY t0.position ASC
Parameters:
[
  209
]
86 0.11 ms
SELECT t0.id AS id_1, t0.id_crypt AS id_crypt_2, t0.name AS name_3, t0.starting_point AS starting_point_4, t0.days AS days_5, t0.is_complete AS is_complete_6, t0.is_last_spot AS is_last_spot_7, t0.guides AS guides_8, t0.date_from AS date_from_9, t0.start_date AS start_date_10, t0.date_to AS date_to_11, t0.registration_deadline AS registration_deadline_12, t0.formalities AS formalities_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.enabled AS enabled_16, t0.is_promoted AS is_promoted_17, t0.is_pre_registered_notified AS is_pre_registered_notified_18, t0.destination_id AS destination_id_19 FROM travel t0 WHERE t0.destination_id = ? ORDER BY t0.date_from DESC
Parameters:
[
  209
]
87 0.11 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.uid AS uid_3, t0.state AS state_4, t0.method AS method_5, t0.payed_at AS payed_at_6, t0.axepta_pay_id AS axepta_pay_id_7, t0.year AS year_8, t0.is_used AS is_used_9, t0.destination_id AS destination_id_10, t0.billing_id AS billing_id_11, t0.user_id AS user_id_12 FROM pre_registration t0 WHERE t0.destination_id = ? AND t0.year = ? AND t0.state IN (?, ?) AND t0.is_used = ?
Parameters:
[
  209
  2026
  "pending_approval"
  "paid"
  0
]
88 0.12 ms
SELECT t0.id AS id_1, t0.camping_car_length AS camping_car_length_2, t0.camping_car_height AS camping_car_height_3, t0.has_animal AS has_animal_4, t0.price AS price_5, t0.total_price AS total_price_6, t0.cygest_export_date AS cygest_export_date_7, t0.state AS state_8, t0.cygest_return AS cygest_return_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.coupon_code AS coupon_code_12, t0.coupon_amount AS coupon_amount_13, t0.uuid AS uuid_14, t0.old_options AS old_options_15, t0.pre_registration_amount AS pre_registration_amount_16, t0.pdf_destination AS pdf_destination_17, t0.authored_by_id AS authored_by_id_18, t0.travel_id AS travel_id_19, t0.billing_id AS billing_id_20 FROM reservation t0 WHERE t0.travel_id = ? AND t0.state IN (?, ?, ?)
Parameters:
[
  24
  "awaiting_down_payment"
  "partially_paid"
  "partially_paid"
]
89 0.10 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.uid AS uid_3, t0.state AS state_4, t0.method AS method_5, t0.payed_at AS payed_at_6, t0.axepta_pay_id AS axepta_pay_id_7, t0.year AS year_8, t0.is_used AS is_used_9, t0.destination_id AS destination_id_10, t0.billing_id AS billing_id_11, t0.user_id AS user_id_12 FROM pre_registration t0 WHERE t0.destination_id = ? AND t0.year = ? AND t0.state IN (?, ?) AND t0.is_used = ?
Parameters:
[
  209
  2026
  "pending_approval"
  "paid"
  0
]
90 0.11 ms
SELECT t0.id AS id_1, t0.camping_car_length AS camping_car_length_2, t0.camping_car_height AS camping_car_height_3, t0.has_animal AS has_animal_4, t0.price AS price_5, t0.total_price AS total_price_6, t0.cygest_export_date AS cygest_export_date_7, t0.state AS state_8, t0.cygest_return AS cygest_return_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.coupon_code AS coupon_code_12, t0.coupon_amount AS coupon_amount_13, t0.uuid AS uuid_14, t0.old_options AS old_options_15, t0.pre_registration_amount AS pre_registration_amount_16, t0.pdf_destination AS pdf_destination_17, t0.authored_by_id AS authored_by_id_18, t0.travel_id AS travel_id_19, t0.billing_id AS billing_id_20 FROM reservation t0 WHERE t0.travel_id = ? AND t0.state IN (?, ?, ?)
Parameters:
[
  24
  "awaiting_down_payment"
  "partially_paid"
  "partially_paid"
]
91 0.09 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = ? LIMIT 1
Parameters:
[
  "LOGO_PATH"
]
92 0.07 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = ? LIMIT 1
Parameters:
[
  "LOGO2X_PATH"
]
93 0.07 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = ? LIMIT 1
Parameters:
[
  "LOGO_PATH"
]
94 0.07 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = ? LIMIT 1
Parameters:
[
  "LOGO2X_PATH"
]
95 0.07 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = ? LIMIT 1
Parameters:
[
  "LOGO_PATH"
]
96 0.06 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = ? LIMIT 1
Parameters:
[
  "LOGO_PATH"
]
97 0.06 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = ? LIMIT 1
Parameters:
[
  "LOGO2X_PATH"
]
98 0.07 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = ? LIMIT 1
Parameters:
[
  "CONTACT_PHONE"
]
99 0.06 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = ? LIMIT 1
Parameters:
[
  "CONTACT_MAIL"
]
100 0.06 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = ? LIMIT 1
Parameters:
[
  "CONTACT_ADDRESS"
]
101 0.06 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = ? LIMIT 1
Parameters:
[
  "CONTACT_ZIP_CODE"
]
102 0.06 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = ? LIMIT 1
Parameters:
[
  "CONTACT_CITY"
]
103 0.07 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = ? LIMIT 1
Parameters:
[
  "CONTACT_OPENING"
]
104 0.06 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = ? LIMIT 1
Parameters:
[
  "CONTACT_LONGITUDE"
]
105 0.06 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = ? LIMIT 1
Parameters:
[
  "CONTACT_LATITUDE"
]
106 0.08 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.type AS type_3, t0.position AS position_4, t0.enabled AS enabled_5 FROM social_network t0 WHERE t0.enabled = ?
Parameters:
[
  1
]
107 0.08 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.sub_items AS sub_items_3 FROM menu_type t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "Footer"
]
108 0.16 ms
SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.type AS type_2, m0_.url AS url_3, m0_.route AS route_4, m0_.position AS position_5, m0_.enabled AS enabled_6, m0_.updated_at AS updated_at_7, m0_.created_at AS created_at_8, m0_.path AS path_9, m0_.has_link AS has_link_10, m0_.parent_id AS parent_id_11, m0_.menu_id AS menu_id_12 FROM menu_item m0_ INNER JOIN menu m1_ ON m0_.menu_id = m1_.id WHERE m1_.type_id = ? AND m0_.parent_id IS NULL AND m0_.enabled = 1 ORDER BY m0_.position ASC
Parameters:
[
  2
]
109 0.09 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.sub_items AS sub_items_3 FROM menu_type t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "Footer"
]
110 0.14 ms
SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.type AS type_2, m0_.url AS url_3, m0_.route AS route_4, m0_.position AS position_5, m0_.enabled AS enabled_6, m0_.updated_at AS updated_at_7, m0_.created_at AS created_at_8, m0_.path AS path_9, m0_.has_link AS has_link_10, m0_.parent_id AS parent_id_11, m0_.menu_id AS menu_id_12 FROM menu_item m0_ INNER JOIN menu m1_ ON m0_.menu_id = m1_.id WHERE m1_.type_id = ? AND m0_.parent_id IS NULL AND m0_.enabled = 1 ORDER BY m0_.position ASC
Parameters:
[
  2
]
111 0.09 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = ? LIMIT 1
Parameters:
[
  "RGPD_CMS_ID"
]
112 0.09 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.enabled AS enabled_5, t0.content AS content_6, t0.seo_id AS seo_id_7 FROM cms t0 WHERE t0.id = ?
Parameters:
[
  "14"
]
113 0.08 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = ? LIMIT 1
Parameters:
[
  "LEGAL_NOTICE_CMS_ID"
]
114 0.08 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.enabled AS enabled_5, t0.content AS content_6, t0.seo_id AS seo_id_7 FROM cms t0 WHERE t0.id = ?
Parameters:
[
  "10"
]
115 0.08 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.meta_description AS meta_description_4, t0.meta_keywords AS meta_keywords_5, t0.og_title AS og_title_6, t0.twitter_card AS twitter_card_7, t0.page_type AS page_type_8, t0.og_image_id AS og_image_id_9, t0.twitter_image_id AS twitter_image_id_10 FROM seo_meta_data t0 WHERE t0.id = ?
Parameters:
[
  952
]
116 0.09 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.meta_description AS meta_description_4, t0.meta_keywords AS meta_keywords_5, t0.og_title AS og_title_6, t0.twitter_card AS twitter_card_7, t0.page_type AS page_type_8, t0.og_image_id AS og_image_id_9, t0.twitter_image_id AS twitter_image_id_10 FROM seo_meta_data t0 WHERE t0.id = ?
Parameters:
[
  956
]

Database Connections

Name Service
default doctrine.dbal.default_connection
old_db doctrine.dbal.old_db_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\Destination\DestinationImage 63
App\Entity\Menu\MenuItem 34
App\Entity\Configuration 17
App\Entity\Travel\Travel 13
App\Entity\Destination\DestinationDay 9
App\Entity\SeoMetaData 8
App\Entity\Travel\Rate 8
App\Entity\Destination\Destination 5
App\Entity\Destination\DestinationMap 5
App\Entity\Travel\Option 5
App\Entity\Appearance\Icon 4
App\Entity\Config\SocialNetwork 3
App\Entity\Cms\Cms 3
App\Entity\Appearance\Pictogram 3
App\Entity\Destination\DestinationHero 2
App\Entity\Menu\Menu 2
App\Entity\Maintenance 1
App\Entity\Destination\DestinationType 1
App\Entity\File 1
App\Entity\Menu\MenuType 1

Entities Mapping

Class Mapping errors
App\Entity\Maintenance No errors.
App\Entity\Configuration No errors.
App\Entity\SeoMetaData No errors.
App\Entity\FileSuperClass No errors.
App\Entity\Image No errors.
App\Entity\SeoImage No errors.
App\Entity\Destination\Destination
  • The field App\Entity\Destination\Destination#suggestions is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Destination\Destination#suggestions does not contain the required 'mappedBy: "suggestions"' attribute.
App\Entity\User
  • The association App\Entity\User#parent refers to the inverse side field App\Entity\User#children which does not exist.
  • The mappings App\Entity\User#subAccounts and App\Entity\User#parent are inconsistent with each other.
App\Entity\Destination\DestinationMap No errors.
App\Entity\Destination\DestinationHero No errors.
App\Entity\Video No errors.
App\Entity\File\Video No errors.
App\Entity\Destination\DestinationHeroVideo No errors.
App\Entity\Destination\DestinationVideo No errors.
App\Entity\Destination\DestinationType No errors.
App\Entity\Destination\DestinationImage No errors.
App\Entity\Destination\DestinationFile No errors.
App\Entity\Destination\DestinationDay No errors.
App\Entity\Appearance\Pictogram No errors.
App\Entity\Country
  • The mappings App\Entity\Country#zone and App\Entity\Zone#countries are inconsistent with each other.
App\Entity\Travel\Travel No errors.
App\Entity\Destination\DestinationQnA No errors.
App\Entity\Travel\Option No errors.
App\Entity\Travel\Rate No errors.
App\Entity\Appearance\Icon No errors.
App\Entity\Config\SocialNetwork No errors.
App\Entity\File No errors.
App\Entity\Menu\MenuItem No errors.
App\Entity\Menu\Menu No errors.
App\Entity\Menu\MenuType No errors.
App\Entity\Cms\Cms No errors.
App\Entity\Reservation\PaymentSuperClass No errors.
App\Entity\Reservation\PreRegistration No errors.
App\Entity\Reservation\Address No errors.
App\Entity\Reservation\Reservation No errors.