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.city AS city_2,
  t0.address AS address_3,
  t0.country AS country_4,
  t0.location AS location_5,
  t0.latitude AS latitude_6,
  t0.longitude AS longitude_7,
  t0.postalCode AS postalCode_8
FROM
  address t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.city AS city_2, t0.address AS address_3, t0.country AS country_4, t0.location AS location_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.postalCode AS postalCode_8 FROM address t0 WHERE t0.id = 2012;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.weight AS weight_3,
  t0.slug AS slug_4,
  t0.parent_id AS parent_id_5
FROM
  category t0
  INNER JOIN hotel_tags ON t0.id = hotel_tags.category_id
WHERE
  hotel_tags.hotel_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.weight AS weight_3, t0.slug AS slug_4, t0.parent_id AS parent_id_5 FROM category t0 INNER JOIN hotel_tags ON t0.id = hotel_tags.category_id WHERE hotel_tags.hotel_id = 2032;

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
  h0_.id AS id_0,
  h0_.name AS name_1,
  h0_.stars AS stars_2,
  h0_.phone AS phone_3,
  h0_.score AS score_4,
  h0_.description AS description_5,
  h0_.area_description AS area_description_6,
  h0_.room_description AS room_description_7,
  h0_.service_description AS service_description_8,
  h0_.restaurant_description AS restaurant_description_9,
  h0_.comments AS comments_10,
  h0_.seo AS seo_11,
  h0_.bookingConditions AS bookingConditions_12,
  h0_.rooms AS rooms_13,
  h0_.slug AS slug_14,
  h0_.email AS email_15,
  h0_.highlighted AS highlighted_16,
  h0_.position AS position_17,
  h0_.searchable AS searchable_18,
  h0_.created AS created_19,
  h0_.updated AS updated_20,
  h0_.bond_instructions AS bond_instructions_21,
  h0_.priority AS priority_22,
  h0_.external AS external_23,
  h0_.source AS source_24,
  h0_.source_code AS source_code_25,
  h0_.cancellation_policy AS cancellation_policy_26,
  h0_.commission AS commission_27,
  h0_.main_image_id AS main_image_id_28,
  h0_.hotel_type_id AS hotel_type_id_29,
  h0_.zone_id AS zone_id_30,
  h0_.address_id AS address_id_31
FROM
  hotel h0_
WHERE
  h0_.searchable = 1
  AND h0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  h0_.priority DESC

SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.stars AS stars_2, h0_.phone AS phone_3, h0_.score AS score_4, h0_.description AS description_5, h0_.area_description AS area_description_6, h0_.room_description AS room_description_7, h0_.service_description AS service_description_8, h0_.restaurant_description AS restaurant_description_9, h0_.comments AS comments_10, h0_.seo AS seo_11, h0_.bookingConditions AS bookingConditions_12, h0_.rooms AS rooms_13, h0_.slug AS slug_14, h0_.email AS email_15, h0_.highlighted AS highlighted_16, h0_.position AS position_17, h0_.searchable AS searchable_18, h0_.created AS created_19, h0_.updated AS updated_20, h0_.bond_instructions AS bond_instructions_21, h0_.priority AS priority_22, h0_.external AS external_23, h0_.source AS source_24, h0_.source_code AS source_code_25, h0_.cancellation_policy AS cancellation_policy_26, h0_.commission AS commission_27, h0_.main_image_id AS main_image_id_28, h0_.hotel_type_id AS hotel_type_id_29, h0_.zone_id AS zone_id_30, h0_.address_id AS address_id_31 FROM hotel h0_ WHERE h0_.searchable = 1 AND h0_.id IN (2032, 2033, 2036, 2039, 2040, 2041, 2042, 2044, 2045, 2047) ORDER BY h0_.priority DESC;

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

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
  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
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          h0_.id AS id_0,
          h0_.name AS name_1,
          h0_.stars AS stars_2,
          h0_.phone AS phone_3,
          h0_.score AS score_4,
          h0_.description AS description_5,
          h0_.area_description AS area_description_6,
          h0_.room_description AS room_description_7,
          h0_.service_description AS service_description_8,
          h0_.restaurant_description AS restaurant_description_9,
          h0_.comments AS comments_10,
          h0_.seo AS seo_11,
          h0_.bookingConditions AS bookingConditions_12,
          h0_.rooms AS rooms_13,
          h0_.slug AS slug_14,
          h0_.email AS email_15,
          h0_.highlighted AS highlighted_16,
          h0_.position AS position_17,
          h0_.searchable AS searchable_18,
          h0_.created AS created_19,
          h0_.updated AS updated_20,
          h0_.bond_instructions AS bond_instructions_21,
          h0_.priority AS priority_22,
          h0_.external AS external_23,
          h0_.source AS source_24,
          h0_.source_code AS source_code_25,
          h0_.cancellation_policy AS cancellation_policy_26,
          h0_.commission AS commission_27
        FROM
          hotel h0_
        WHERE
          h0_.searchable = 1
        ORDER BY
          h0_.priority DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.stars AS stars_2, h0_.phone AS phone_3, h0_.score AS score_4, h0_.description AS description_5, h0_.area_description AS area_description_6, h0_.room_description AS room_description_7, h0_.service_description AS service_description_8, h0_.restaurant_description AS restaurant_description_9, h0_.comments AS comments_10, h0_.seo AS seo_11, h0_.bookingConditions AS bookingConditions_12, h0_.rooms AS rooms_13, h0_.slug AS slug_14, h0_.email AS email_15, h0_.highlighted AS highlighted_16, h0_.position AS position_17, h0_.searchable AS searchable_18, h0_.created AS created_19, h0_.updated AS updated_20, h0_.bond_instructions AS bond_instructions_21, h0_.priority AS priority_22, h0_.external AS external_23, h0_.source AS source_24, h0_.source_code AS source_code_25, h0_.cancellation_policy AS cancellation_policy_26, h0_.commission AS commission_27 FROM hotel h0_ WHERE h0_.searchable = 1 ORDER BY h0_.priority DESC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      priority_22
    FROM
      (
        SELECT
          h0_.id AS id_0,
          h0_.name AS name_1,
          h0_.stars AS stars_2,
          h0_.phone AS phone_3,
          h0_.score AS score_4,
          h0_.description AS description_5,
          h0_.area_description AS area_description_6,
          h0_.room_description AS room_description_7,
          h0_.service_description AS service_description_8,
          h0_.restaurant_description AS restaurant_description_9,
          h0_.comments AS comments_10,
          h0_.seo AS seo_11,
          h0_.bookingConditions AS bookingConditions_12,
          h0_.rooms AS rooms_13,
          h0_.slug AS slug_14,
          h0_.email AS email_15,
          h0_.highlighted AS highlighted_16,
          h0_.position AS position_17,
          h0_.searchable AS searchable_18,
          h0_.created AS created_19,
          h0_.updated AS updated_20,
          h0_.bond_instructions AS bond_instructions_21,
          h0_.priority AS priority_22,
          h0_.external AS external_23,
          h0_.source AS source_24,
          h0_.source_code AS source_code_25,
          h0_.cancellation_policy AS cancellation_policy_26,
          h0_.commission AS commission_27
        FROM
          hotel h0_
        WHERE
          h0_.searchable = 1
      ) dctrn_result_inner
    ORDER BY
      priority_22 DESC
  ) dctrn_result
LIMIT
  10
OFFSET
  140

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, priority_22 FROM (SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.stars AS stars_2, h0_.phone AS phone_3, h0_.score AS score_4, h0_.description AS description_5, h0_.area_description AS area_description_6, h0_.room_description AS room_description_7, h0_.service_description AS service_description_8, h0_.restaurant_description AS restaurant_description_9, h0_.comments AS comments_10, h0_.seo AS seo_11, h0_.bookingConditions AS bookingConditions_12, h0_.rooms AS rooms_13, h0_.slug AS slug_14, h0_.email AS email_15, h0_.highlighted AS highlighted_16, h0_.position AS position_17, h0_.searchable AS searchable_18, h0_.created AS created_19, h0_.updated AS updated_20, h0_.bond_instructions AS bond_instructions_21, h0_.priority AS priority_22, h0_.external AS external_23, h0_.source AS source_24, h0_.source_code AS source_code_25, h0_.cancellation_policy AS cancellation_policy_26, h0_.commission AS commission_27 FROM hotel h0_ WHERE h0_.searchable = 1) dctrn_result_inner ORDER BY priority_22 DESC) dctrn_result LIMIT 10 OFFSET 140;