Symfony Profiler

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
  1870

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 1870;

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 (3965, 3966, 3967, 3968, 3969, 3970, 3971, 3972, 3973, 3974) 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.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
  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;