Symfony Profiler

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

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;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.value AS value_3
FROM
  configuration t0
WHERE
  t0.label = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = 'LOGO_PATH' LIMIT 1;

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 = ?
  AND t0.page_type = ?
LIMIT
  1

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 = 'costa-rica' AND t0.page_type = 'country' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.title AS title_4,
  t5.id AS id_6,
  t5.path AS path_7,
  t5.alt AS alt_8,
  t5.title AS title_9,
  t5.country_id AS country_id_10
FROM
  country t0
  LEFT JOIN country_image t5 ON t5.country_id = t0.id
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.title AS title_4, t5.id AS id_6, t5.path AS path_7, t5.alt AS alt_8, t5.title AS title_9, t5.country_id AS country_id_10 FROM country t0 LEFT JOIN country_image t5 ON t5.country_id = t0.id WHERE t0.slug = 'costa-rica' LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.title AS title_3,
  d1_.id AS id_4,
  d1_.name AS name_5,
  d1_.title AS title_6,
  d1_.subtitle AS subtitle_7,
  d1_.cygest_code AS cygest_code_8,
  d1_.cygest_name AS cygest_name_9,
  d1_.days AS days_10,
  d1_.nights AS nights_11,
  d1_.soon AS soon_12,
  d1_.is_health_situation AS is_health_situation_13,
  d1_.description_introduction AS description_introduction_14,
  d1_.description_resume AS description_resume_15,
  d1_.description_body AS description_body_16,
  d1_.camping_car_circuit AS camping_car_circuit_17,
  d1_.average_distance AS average_distance_18,
  d1_.days_without_driving AS days_without_driving_19,
  d1_.youtube AS youtube_20,
  d1_.our_prices_include AS our_prices_include_21,
  d1_.our_prices_does_not_include AS our_prices_does_not_include_22,
  d1_.rates_details AS rates_details_23,
  d1_.created_at AS created_at_24,
  d1_.updated_at AS updated_at_25,
  d1_.enabled AS enabled_26,
  d1_.is_archive AS is_archive_27,
  d1_.we_like AS we_like_28,
  d1_.scale AS scale_29,
  d1_.is_upon_request AS is_upon_request_30,
  d1_.is_new AS is_new_31,
  d1_.is_pre_registration_allowed AS is_pre_registration_allowed_32,
  d1_.reservation_limit AS reservation_limit_33,
  d1_.is_animal_forbidden AS is_animal_forbidden_34,
  d1_.author_id AS author_id_35,
  d1_.type_id AS type_id_36,
  d1_.seo_id AS seo_id_37
FROM
  country c0_
  LEFT JOIN destination_country d2_ ON c0_.id = d2_.country_id
  LEFT JOIN destination d1_ ON d1_.id = d2_.destination_id
  AND (d1_.is_archive = 0)
WHERE
  c0_.slug = ?

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.title AS title_3, d1_.id AS id_4, d1_.name AS name_5, d1_.title AS title_6, d1_.subtitle AS subtitle_7, d1_.cygest_code AS cygest_code_8, d1_.cygest_name AS cygest_name_9, d1_.days AS days_10, d1_.nights AS nights_11, d1_.soon AS soon_12, d1_.is_health_situation AS is_health_situation_13, d1_.description_introduction AS description_introduction_14, d1_.description_resume AS description_resume_15, d1_.description_body AS description_body_16, d1_.camping_car_circuit AS camping_car_circuit_17, d1_.average_distance AS average_distance_18, d1_.days_without_driving AS days_without_driving_19, d1_.youtube AS youtube_20, d1_.our_prices_include AS our_prices_include_21, d1_.our_prices_does_not_include AS our_prices_does_not_include_22, d1_.rates_details AS rates_details_23, d1_.created_at AS created_at_24, d1_.updated_at AS updated_at_25, d1_.enabled AS enabled_26, d1_.is_archive AS is_archive_27, d1_.we_like AS we_like_28, d1_.scale AS scale_29, d1_.is_upon_request AS is_upon_request_30, d1_.is_new AS is_new_31, d1_.is_pre_registration_allowed AS is_pre_registration_allowed_32, d1_.reservation_limit AS reservation_limit_33, d1_.is_animal_forbidden AS is_animal_forbidden_34, d1_.author_id AS author_id_35, d1_.type_id AS type_id_36, d1_.seo_id AS seo_id_37 FROM country c0_ LEFT JOIN destination_country d2_ ON c0_.id = d2_.country_id LEFT JOIN destination d1_ ON d1_.id = d2_.destination_id AND (d1_.is_archive = 0) WHERE c0_.slug = 'costa-rica';

SELECT
  t0.id AS id_1,
  t0.path AS path_2,
  t0.alt AS alt_3,
  t0.title AS title_4,
  t0.destination_id AS destination_id_5
FROM
  destination_map t0
WHERE
  t0.destination_id = ?

SELECT t0.id AS id_1, t0.path AS path_2, t0.alt AS alt_3, t0.title AS title_4, t0.destination_id AS destination_id_5 FROM destination_map t0 WHERE t0.destination_id = 205;

SELECT
  t0.id AS id_1,
  t0.path AS path_2,
  t0.alt AS alt_3,
  t0.title AS title_4,
  t0.destination_id AS destination_id_5
FROM
  destination_hero t0
WHERE
  t0.destination_id = ?

SELECT t0.id AS id_1, t0.path AS path_2, t0.alt AS alt_3, t0.title AS title_4, t0.destination_id AS destination_id_5 FROM destination_hero t0 WHERE t0.destination_id = 205;

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 = ?

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 = 205;

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 = ?

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 = 205;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.value AS value_3
FROM
  configuration t0
WHERE
  t0.label = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = 'FAVICON_PATH' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.value AS value_3
FROM
  configuration t0
WHERE
  t0.label = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = 'ICON_MOBILE_PATH' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.value AS value_3
FROM
  configuration t0
WHERE
  t0.label = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = 'GOOGLE_TAG_MANAGER' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.value AS value_3
FROM
  configuration t0
WHERE
  t0.label = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = 'CONTACT_PHONE' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.value AS value_3
FROM
  configuration t0
WHERE
  t0.label = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = 'CONTACT_MAIL' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.value AS value_3
FROM
  configuration t0
WHERE
  t0.label = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = 'CONTACT_ADDRESS' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.value AS value_3
FROM
  configuration t0
WHERE
  t0.label = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = 'CONTACT_ZIP_CODE' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.value AS value_3
FROM
  configuration t0
WHERE
  t0.label = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = 'CONTACT_CITY' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.value AS value_3
FROM
  configuration t0
WHERE
  t0.label = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = 'CONTACT_OPENING' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.value AS value_3
FROM
  configuration t0
WHERE
  t0.label = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = 'CONTACT_LONGITUDE' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.value AS value_3
FROM
  configuration t0
WHERE
  t0.label = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = 'CONTACT_LATITUDE' LIMIT 1;

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 = ?

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 = 1;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.value AS value_3
FROM
  configuration t0
WHERE
  t0.label = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = 'BROCHURE_FILE_ID' LIMIT 1;

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 = ?

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 = '13';