Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.path AS path_4,
  t0.file_type AS file_type_5
FROM
  image t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.path AS path_4, t0.file_type AS file_type_5 FROM image t0 WHERE t0.id = 8176;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.seo AS seo_4,
  t0.bookingConditions AS bookingConditions_5,
  t0.slug AS slug_6,
  t0.tax AS tax_7,
  t0.add_tax AS add_tax_8,
  t0.min_days AS min_days_9,
  t0.created AS created_10,
  t0.updated AS updated_11,
  t0.price_rate_model AS price_rate_model_12,
  t0.product_name AS product_name_13,
  t0.bond_instructions AS bond_instructions_14,
  t0.show_tax AS show_tax_15,
  t0.active AS active_16,
  t0.main_image_id AS main_image_id_17,
  t0.zone_id AS zone_id_18,
  t0.destination_id AS destination_id_19,
  t0.payment_plan_id AS payment_plan_id_20,
  t0.product_type,
  t0.period AS period_21,
  t0.min_people AS min_people_22,
  t0.price AS price_23,
  t0.sale_online AS sale_online_24
FROM
  product t0
WHERE
  t0.destination_id = ?
  AND t0.product_type IN (
    'product', 'ski', 'activity', 'pack'
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.seo AS seo_4, t0.bookingConditions AS bookingConditions_5, t0.slug AS slug_6, t0.tax AS tax_7, t0.add_tax AS add_tax_8, t0.min_days AS min_days_9, t0.created AS created_10, t0.updated AS updated_11, t0.price_rate_model AS price_rate_model_12, t0.product_name AS product_name_13, t0.bond_instructions AS bond_instructions_14, t0.show_tax AS show_tax_15, t0.active AS active_16, t0.main_image_id AS main_image_id_17, t0.zone_id AS zone_id_18, t0.destination_id AS destination_id_19, t0.payment_plan_id AS payment_plan_id_20, t0.product_type, t0.period AS period_21, t0.min_people AS min_people_22, t0.price AS price_23, t0.sale_online AS sale_online_24 FROM product t0 WHERE t0.destination_id = 50 AND t0.product_type IN ('product', 'ski', 'activity', 'pack');

SELECT
  d0_.id AS id_0,
  d0_.name AS name_1,
  d0_.location AS location_2,
  d0_.description AS description_3,
  d0_.seo AS seo_4,
  d0_.slug AS slug_5,
  d0_.created AS created_6,
  d0_.updated AS updated_7,
  d0_.priority AS priority_8,
  d0_.active AS active_9,
  d0_.ski_max_height AS ski_max_height_10,
  d0_.ski_min_height AS ski_min_height_11,
  d0_.ski_kms AS ski_kms_12,
  d0_.ski_slopes AS ski_slopes_13,
  d0_.ski_greens AS ski_greens_14,
  d0_.ski_blues AS ski_blues_15,
  d0_.ski_reds AS ski_reds_16,
  d0_.ski_blacks AS ski_blacks_17,
  d0_.ski_facilities AS ski_facilities_18,
  d0_.ski_services AS ski_services_19,
  d0_.ski_forecast AS ski_forecast_20,
  d0_.geo_location_latitude AS geo_location_latitude_21,
  d0_.geo_location_longitude AS geo_location_longitude_22,
  d0_.main_image_id AS main_image_id_23,
  d0_.zone_id AS zone_id_24,
  d0_.category_id AS category_id_25
FROM
  destination d0_
  INNER JOIN category c1_ ON d0_.category_id = c1_.id
WHERE
  c1_.id = ?
  AND d0_.active = 1
  AND d0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  d0_.priority DESC,
  d0_.id DESC

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.location AS location_2, d0_.description AS description_3, d0_.seo AS seo_4, d0_.slug AS slug_5, d0_.created AS created_6, d0_.updated AS updated_7, d0_.priority AS priority_8, d0_.active AS active_9, d0_.ski_max_height AS ski_max_height_10, d0_.ski_min_height AS ski_min_height_11, d0_.ski_kms AS ski_kms_12, d0_.ski_slopes AS ski_slopes_13, d0_.ski_greens AS ski_greens_14, d0_.ski_blues AS ski_blues_15, d0_.ski_reds AS ski_reds_16, d0_.ski_blacks AS ski_blacks_17, d0_.ski_facilities AS ski_facilities_18, d0_.ski_services AS ski_services_19, d0_.ski_forecast AS ski_forecast_20, d0_.geo_location_latitude AS geo_location_latitude_21, d0_.geo_location_longitude AS geo_location_longitude_22, d0_.main_image_id AS main_image_id_23, d0_.zone_id AS zone_id_24, d0_.category_id AS category_id_25 FROM destination d0_ INNER JOIN category c1_ ON d0_.category_id = c1_.id WHERE c1_.id = 2563 AND d0_.active = 1 AND d0_.id IN (50, 45, 44, 35, 34, 33, 32, 30, 29, 27) ORDER BY d0_.priority DESC, d0_.id DESC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.teaser AS teaser_3,
  t0.description AS description_4,
  t0.period AS period_5,
  t0.seo AS seo_6,
  t0.slug AS slug_7,
  t0.price AS price_8,
  t0.frontpage AS frontpage_9,
  t0.link AS link_10,
  t0.created AS created_11,
  t0.updated AS updated_12,
  t0.webform AS webform_13,
  t0.priority AS priority_14,
  t0.image_id AS image_id_15,
  t0.header_image_id AS header_image_id_16,
  t0.tag_id AS tag_id_17,
  t0.page_id AS page_id_18,
  t0.menu_id AS menu_id_19
FROM
  offer t0
WHERE
  t0.menu_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.teaser AS teaser_3, t0.description AS description_4, t0.period AS period_5, t0.seo AS seo_6, t0.slug AS slug_7, t0.price AS price_8, t0.frontpage AS frontpage_9, t0.link AS link_10, t0.created AS created_11, t0.updated AS updated_12, t0.webform AS webform_13, t0.priority AS priority_14, t0.image_id AS image_id_15, t0.header_image_id AS header_image_id_16, t0.tag_id AS tag_id_17, t0.page_id AS page_id_18, t0.menu_id AS menu_id_19 FROM offer t0 WHERE t0.menu_id = 33;

SELECT
  t0.id AS id_1,
  t0.title AS title_2
FROM
  menu t0

SELECT t0.id AS id_1, t0.title AS title_2 FROM menu t0;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.weight AS weight_2,
  c0_.slug AS slug_3,
  c0_.parent_id AS parent_id_4
FROM
  category c0_
  INNER JOIN category c1_ ON c0_.parent_id = c1_.id
WHERE
  c1_.name = ?

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.weight AS weight_2, c0_.slug AS slug_3, c0_.parent_id AS parent_id_4 FROM category c0_ INNER JOIN category c1_ ON c0_.parent_id = c1_.id WHERE c1_.name = 'Tipos de destino';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.config_key AS config_key_3,
  t0.settings AS settings_4
FROM
  configuration t0
WHERE
  t0.config_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.config_key AS config_key_3, t0.settings AS settings_4 FROM configuration t0 WHERE t0.config_key = 'homepage' LIMIT 1;

SELECT
  DISTINCT d0_.id AS id_0,
  d0_.priority AS priority_1,
  d0_.id AS id_2
FROM
  destination d0_
  INNER JOIN category c1_ ON d0_.category_id = c1_.id
WHERE
  c1_.id = ?
  AND d0_.active = 1
ORDER BY
  d0_.priority DESC,
  d0_.id DESC
LIMIT
  10
OFFSET
  30

SELECT DISTINCT d0_.id AS id_0, d0_.priority AS priority_1, d0_.id AS id_2 FROM destination d0_ INNER JOIN category c1_ ON d0_.category_id = c1_.id WHERE c1_.id = 2563 AND d0_.active = 1 ORDER BY d0_.priority DESC, d0_.id DESC LIMIT 10 OFFSET 30;

SELECT
  count(DISTINCT d0_.id) AS sclr_0
FROM
  destination d0_
  INNER JOIN category c1_ ON d0_.category_id = c1_.id
WHERE
  c1_.id = ?
  AND d0_.active = 1

SELECT count(DISTINCT d0_.id) AS sclr_0 FROM destination d0_ INNER JOIN category c1_ ON d0_.category_id = c1_.id WHERE c1_.id = 2563 AND d0_.active = 1;