Symfony Profiler

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.slug = ?
LIMIT
  1

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.slug = 'hotel-y-forfait-fin-de-semana-grandvalira' LIMIT 1;

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.product_type,
  t0.period AS period_20,
  t0.min_people AS min_people_21,
  t0.price AS price_22,
  t0.sale_online AS sale_online_23
FROM
  product t0
  INNER JOIN offer_product ON t0.id = offer_product.product_id
WHERE
  offer_product.offer_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.product_type, t0.period AS period_20, t0.min_people AS min_people_21, t0.price AS price_22, t0.sale_online AS sale_online_23 FROM product t0 INNER JOIN offer_product ON t0.id = offer_product.product_id WHERE offer_product.offer_id = 79 AND t0.product_type IN ('product', 'ski', 'activity', 'pack');

SELECT
  r.id,
  r.`date`,
  r.prices,
  r.name,
  r.`percentage` as percentage,
  r.`days`
FROM
  product_rates p
  JOIN price_rate r on (r.id = p.rate_id)
WHERE
  p.product_id = ?
  AND r.date >= ?
ORDER BY
  r.date ASC
LIMIT
  0, 1

SELECT r.id, r.`date`, r.prices, r.name, r.`percentage` as percentage, r.`days`
            FROM product_rates p
            JOIN price_rate r on (r.id = p.rate_id)
            WHERE p.product_id = 1405
            AND r.date >= '2026-03-24'
            ORDER BY r.date ASC
            LIMIT 0,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_
  INNER JOIN hotel_product h2_ ON h0_.id = h2_.hotel_id
  INNER JOIN product p1_ ON p1_.id = h2_.product_id
  AND p1_.product_type IN (
    'product', 'ski', 'activity', 'pack'
  )
WHERE
  p1_.id = ?
  AND h0_.external = ?

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_ INNER JOIN hotel_product h2_ ON h0_.id = h2_.hotel_id INNER JOIN product p1_ ON p1_.id = h2_.product_id AND p1_.product_type IN ('product', 'ski', 'activity', 'pack') WHERE p1_.id = 1405 AND h0_.external = 0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.location AS location_3,
  t0.description AS description_4,
  t0.seo AS seo_5,
  t0.slug AS slug_6,
  t0.created AS created_7,
  t0.updated AS updated_8,
  t0.priority AS priority_9,
  t0.active AS active_10,
  t0.ski_max_height AS ski_max_height_11,
  t0.ski_min_height AS ski_min_height_12,
  t0.ski_kms AS ski_kms_13,
  t0.ski_slopes AS ski_slopes_14,
  t0.ski_greens AS ski_greens_15,
  t0.ski_blues AS ski_blues_16,
  t0.ski_reds AS ski_reds_17,
  t0.ski_blacks AS ski_blacks_18,
  t0.ski_facilities AS ski_facilities_19,
  t0.ski_services AS ski_services_20,
  t0.ski_forecast AS ski_forecast_21,
  t0.geo_location_latitude AS geo_location_latitude_22,
  t0.geo_location_longitude AS geo_location_longitude_23,
  t0.main_image_id AS main_image_id_24,
  t0.zone_id AS zone_id_25,
  t0.category_id AS category_id_26
FROM
  destination t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.location AS location_3, t0.description AS description_4, t0.seo AS seo_5, t0.slug AS slug_6, t0.created AS created_7, t0.updated AS updated_8, t0.priority AS priority_9, t0.active AS active_10, t0.ski_max_height AS ski_max_height_11, t0.ski_min_height AS ski_min_height_12, t0.ski_kms AS ski_kms_13, t0.ski_slopes AS ski_slopes_14, t0.ski_greens AS ski_greens_15, t0.ski_blues AS ski_blues_16, t0.ski_reds AS ski_reds_17, t0.ski_blacks AS ski_blacks_18, t0.ski_facilities AS ski_facilities_19, t0.ski_services AS ski_services_20, t0.ski_forecast AS ski_forecast_21, t0.geo_location_latitude AS geo_location_latitude_22, t0.geo_location_longitude AS geo_location_longitude_23, t0.main_image_id AS main_image_id_24, t0.zone_id AS zone_id_25, t0.category_id AS category_id_26 FROM destination t0 WHERE t0.id = 7;

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,
  6371 * 2 * ASIN(
    SQRT(
      POWER(
        SIN(
          RADIANS(
            ? - ABS(a1_.latitude)
          )
        ),
        2
      ) + COS(
        RADIANS(?)
      ) * COS(
        RADIANS(
          ABS(a1_.latitude)
        )
      ) * POWER(
        SIN(
          RADIANS(? - a1_.longitude)
        ),
        2
      )
    )
  ) AS sclr_28,
  h0_.main_image_id AS main_image_id_29,
  h0_.hotel_type_id AS hotel_type_id_30,
  h0_.zone_id AS zone_id_31,
  h0_.address_id AS address_id_32
FROM
  hotel h0_
  INNER JOIN address a1_ ON h0_.address_id = a1_.id
WHERE
  h0_.searchable = 1
  AND h0_.external = ?
HAVING
  (sclr_28 < ?)

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, 6371 * 2 * ASIN(SQRT(POWER(SIN(RADIANS(42.5421978 - ABS(a1_.latitude))),2) + COS(RADIANS(42.5421978)) * COS(RADIANS(ABS(a1_.latitude))) * POWER(SIN(RADIANS(1.732591 - a1_.longitude)),2))) AS sclr_28, h0_.main_image_id AS main_image_id_29, h0_.hotel_type_id AS hotel_type_id_30, h0_.zone_id AS zone_id_31, h0_.address_id AS address_id_32 FROM hotel h0_ INNER JOIN address a1_ ON h0_.address_id = a1_.id WHERE h0_.searchable = 1 AND h0_.external = 0 HAVING (sclr_28 < 150);

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.stars AS stars_3,
  t0.phone AS phone_4,
  t0.score AS score_5,
  t0.description AS description_6,
  t0.area_description AS area_description_7,
  t0.room_description AS room_description_8,
  t0.service_description AS service_description_9,
  t0.restaurant_description AS restaurant_description_10,
  t0.comments AS comments_11,
  t0.seo AS seo_12,
  t0.bookingConditions AS bookingConditions_13,
  t0.rooms AS rooms_14,
  t0.slug AS slug_15,
  t0.email AS email_16,
  t0.highlighted AS highlighted_17,
  t0.position AS position_18,
  t0.searchable AS searchable_19,
  t0.created AS created_20,
  t0.updated AS updated_21,
  t0.bond_instructions AS bond_instructions_22,
  t0.priority AS priority_23,
  t0.external AS external_24,
  t0.source AS source_25,
  t0.source_code AS source_code_26,
  t0.cancellation_policy AS cancellation_policy_27,
  t0.commission AS commission_28,
  t0.main_image_id AS main_image_id_29,
  t0.hotel_type_id AS hotel_type_id_30,
  t0.zone_id AS zone_id_31,
  t0.address_id AS address_id_32
FROM
  hotel t0
WHERE
  t0.source = ?
  AND t0.source_code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.stars AS stars_3, t0.phone AS phone_4, t0.score AS score_5, t0.description AS description_6, t0.area_description AS area_description_7, t0.room_description AS room_description_8, t0.service_description AS service_description_9, t0.restaurant_description AS restaurant_description_10, t0.comments AS comments_11, t0.seo AS seo_12, t0.bookingConditions AS bookingConditions_13, t0.rooms AS rooms_14, t0.slug AS slug_15, t0.email AS email_16, t0.highlighted AS highlighted_17, t0.position AS position_18, t0.searchable AS searchable_19, t0.created AS created_20, t0.updated AS updated_21, t0.bond_instructions AS bond_instructions_22, t0.priority AS priority_23, t0.external AS external_24, t0.source AS source_25, t0.source_code AS source_code_26, t0.cancellation_policy AS cancellation_policy_27, t0.commission AS commission_28, t0.main_image_id AS main_image_id_29, t0.hotel_type_id AS hotel_type_id_30, t0.zone_id AS zone_id_31, t0.address_id AS address_id_32 FROM hotel t0 WHERE t0.source = 'TG#YPL#11111' AND t0.source_code = 91264 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.stars AS stars_3,
  t0.phone AS phone_4,
  t0.score AS score_5,
  t0.description AS description_6,
  t0.area_description AS area_description_7,
  t0.room_description AS room_description_8,
  t0.service_description AS service_description_9,
  t0.restaurant_description AS restaurant_description_10,
  t0.comments AS comments_11,
  t0.seo AS seo_12,
  t0.bookingConditions AS bookingConditions_13,
  t0.rooms AS rooms_14,
  t0.slug AS slug_15,
  t0.email AS email_16,
  t0.highlighted AS highlighted_17,
  t0.position AS position_18,
  t0.searchable AS searchable_19,
  t0.created AS created_20,
  t0.updated AS updated_21,
  t0.bond_instructions AS bond_instructions_22,
  t0.priority AS priority_23,
  t0.external AS external_24,
  t0.source AS source_25,
  t0.source_code AS source_code_26,
  t0.cancellation_policy AS cancellation_policy_27,
  t0.commission AS commission_28,
  t0.main_image_id AS main_image_id_29,
  t0.hotel_type_id AS hotel_type_id_30,
  t0.zone_id AS zone_id_31,
  t0.address_id AS address_id_32
FROM
  hotel t0
WHERE
  t0.source = ?
  AND t0.source_code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.stars AS stars_3, t0.phone AS phone_4, t0.score AS score_5, t0.description AS description_6, t0.area_description AS area_description_7, t0.room_description AS room_description_8, t0.service_description AS service_description_9, t0.restaurant_description AS restaurant_description_10, t0.comments AS comments_11, t0.seo AS seo_12, t0.bookingConditions AS bookingConditions_13, t0.rooms AS rooms_14, t0.slug AS slug_15, t0.email AS email_16, t0.highlighted AS highlighted_17, t0.position AS position_18, t0.searchable AS searchable_19, t0.created AS created_20, t0.updated AS updated_21, t0.bond_instructions AS bond_instructions_22, t0.priority AS priority_23, t0.external AS external_24, t0.source AS source_25, t0.source_code AS source_code_26, t0.cancellation_policy AS cancellation_policy_27, t0.commission AS commission_28, t0.main_image_id AS main_image_id_29, t0.hotel_type_id AS hotel_type_id_30, t0.zone_id AS zone_id_31, t0.address_id AS address_id_32 FROM hotel t0 WHERE t0.source = 'TG#HPRG#20273' AND t0.source_code = 29886 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.stars AS stars_3,
  t0.phone AS phone_4,
  t0.score AS score_5,
  t0.description AS description_6,
  t0.area_description AS area_description_7,
  t0.room_description AS room_description_8,
  t0.service_description AS service_description_9,
  t0.restaurant_description AS restaurant_description_10,
  t0.comments AS comments_11,
  t0.seo AS seo_12,
  t0.bookingConditions AS bookingConditions_13,
  t0.rooms AS rooms_14,
  t0.slug AS slug_15,
  t0.email AS email_16,
  t0.highlighted AS highlighted_17,
  t0.position AS position_18,
  t0.searchable AS searchable_19,
  t0.created AS created_20,
  t0.updated AS updated_21,
  t0.bond_instructions AS bond_instructions_22,
  t0.priority AS priority_23,
  t0.external AS external_24,
  t0.source AS source_25,
  t0.source_code AS source_code_26,
  t0.cancellation_policy AS cancellation_policy_27,
  t0.commission AS commission_28,
  t0.main_image_id AS main_image_id_29,
  t0.hotel_type_id AS hotel_type_id_30,
  t0.zone_id AS zone_id_31,
  t0.address_id AS address_id_32
FROM
  hotel t0
WHERE
  t0.source = ?
  AND t0.source_code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.stars AS stars_3, t0.phone AS phone_4, t0.score AS score_5, t0.description AS description_6, t0.area_description AS area_description_7, t0.room_description AS room_description_8, t0.service_description AS service_description_9, t0.restaurant_description AS restaurant_description_10, t0.comments AS comments_11, t0.seo AS seo_12, t0.bookingConditions AS bookingConditions_13, t0.rooms AS rooms_14, t0.slug AS slug_15, t0.email AS email_16, t0.highlighted AS highlighted_17, t0.position AS position_18, t0.searchable AS searchable_19, t0.created AS created_20, t0.updated AS updated_21, t0.bond_instructions AS bond_instructions_22, t0.priority AS priority_23, t0.external AS external_24, t0.source AS source_25, t0.source_code AS source_code_26, t0.cancellation_policy AS cancellation_policy_27, t0.commission AS commission_28, t0.main_image_id AS main_image_id_29, t0.hotel_type_id AS hotel_type_id_30, t0.zone_id AS zone_id_31, t0.address_id AS address_id_32 FROM hotel t0 WHERE t0.source = 'TG#HPRG#20273' AND t0.source_code = 28527 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.stars AS stars_3,
  t0.phone AS phone_4,
  t0.score AS score_5,
  t0.description AS description_6,
  t0.area_description AS area_description_7,
  t0.room_description AS room_description_8,
  t0.service_description AS service_description_9,
  t0.restaurant_description AS restaurant_description_10,
  t0.comments AS comments_11,
  t0.seo AS seo_12,
  t0.bookingConditions AS bookingConditions_13,
  t0.rooms AS rooms_14,
  t0.slug AS slug_15,
  t0.email AS email_16,
  t0.highlighted AS highlighted_17,
  t0.position AS position_18,
  t0.searchable AS searchable_19,
  t0.created AS created_20,
  t0.updated AS updated_21,
  t0.bond_instructions AS bond_instructions_22,
  t0.priority AS priority_23,
  t0.external AS external_24,
  t0.source AS source_25,
  t0.source_code AS source_code_26,
  t0.cancellation_policy AS cancellation_policy_27,
  t0.commission AS commission_28,
  t0.main_image_id AS main_image_id_29,
  t0.hotel_type_id AS hotel_type_id_30,
  t0.zone_id AS zone_id_31,
  t0.address_id AS address_id_32
FROM
  hotel t0
WHERE
  t0.source = ?
  AND t0.source_code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.stars AS stars_3, t0.phone AS phone_4, t0.score AS score_5, t0.description AS description_6, t0.area_description AS area_description_7, t0.room_description AS room_description_8, t0.service_description AS service_description_9, t0.restaurant_description AS restaurant_description_10, t0.comments AS comments_11, t0.seo AS seo_12, t0.bookingConditions AS bookingConditions_13, t0.rooms AS rooms_14, t0.slug AS slug_15, t0.email AS email_16, t0.highlighted AS highlighted_17, t0.position AS position_18, t0.searchable AS searchable_19, t0.created AS created_20, t0.updated AS updated_21, t0.bond_instructions AS bond_instructions_22, t0.priority AS priority_23, t0.external AS external_24, t0.source AS source_25, t0.source_code AS source_code_26, t0.cancellation_policy AS cancellation_policy_27, t0.commission AS commission_28, t0.main_image_id AS main_image_id_29, t0.hotel_type_id AS hotel_type_id_30, t0.zone_id AS zone_id_31, t0.address_id AS address_id_32 FROM hotel t0 WHERE t0.source = 'TG#HPRG#20273' AND t0.source_code = 27036 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.stars AS stars_3,
  t0.phone AS phone_4,
  t0.score AS score_5,
  t0.description AS description_6,
  t0.area_description AS area_description_7,
  t0.room_description AS room_description_8,
  t0.service_description AS service_description_9,
  t0.restaurant_description AS restaurant_description_10,
  t0.comments AS comments_11,
  t0.seo AS seo_12,
  t0.bookingConditions AS bookingConditions_13,
  t0.rooms AS rooms_14,
  t0.slug AS slug_15,
  t0.email AS email_16,
  t0.highlighted AS highlighted_17,
  t0.position AS position_18,
  t0.searchable AS searchable_19,
  t0.created AS created_20,
  t0.updated AS updated_21,
  t0.bond_instructions AS bond_instructions_22,
  t0.priority AS priority_23,
  t0.external AS external_24,
  t0.source AS source_25,
  t0.source_code AS source_code_26,
  t0.cancellation_policy AS cancellation_policy_27,
  t0.commission AS commission_28,
  t0.main_image_id AS main_image_id_29,
  t0.hotel_type_id AS hotel_type_id_30,
  t0.zone_id AS zone_id_31,
  t0.address_id AS address_id_32
FROM
  hotel t0
WHERE
  t0.source = ?
  AND t0.source_code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.stars AS stars_3, t0.phone AS phone_4, t0.score AS score_5, t0.description AS description_6, t0.area_description AS area_description_7, t0.room_description AS room_description_8, t0.service_description AS service_description_9, t0.restaurant_description AS restaurant_description_10, t0.comments AS comments_11, t0.seo AS seo_12, t0.bookingConditions AS bookingConditions_13, t0.rooms AS rooms_14, t0.slug AS slug_15, t0.email AS email_16, t0.highlighted AS highlighted_17, t0.position AS position_18, t0.searchable AS searchable_19, t0.created AS created_20, t0.updated AS updated_21, t0.bond_instructions AS bond_instructions_22, t0.priority AS priority_23, t0.external AS external_24, t0.source AS source_25, t0.source_code AS source_code_26, t0.cancellation_policy AS cancellation_policy_27, t0.commission AS commission_28, t0.main_image_id AS main_image_id_29, t0.hotel_type_id AS hotel_type_id_30, t0.zone_id AS zone_id_31, t0.address_id AS address_id_32 FROM hotel t0 WHERE t0.source = 'TG#HPRG#20273' AND t0.source_code = 26268 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.stars AS stars_3,
  t0.phone AS phone_4,
  t0.score AS score_5,
  t0.description AS description_6,
  t0.area_description AS area_description_7,
  t0.room_description AS room_description_8,
  t0.service_description AS service_description_9,
  t0.restaurant_description AS restaurant_description_10,
  t0.comments AS comments_11,
  t0.seo AS seo_12,
  t0.bookingConditions AS bookingConditions_13,
  t0.rooms AS rooms_14,
  t0.slug AS slug_15,
  t0.email AS email_16,
  t0.highlighted AS highlighted_17,
  t0.position AS position_18,
  t0.searchable AS searchable_19,
  t0.created AS created_20,
  t0.updated AS updated_21,
  t0.bond_instructions AS bond_instructions_22,
  t0.priority AS priority_23,
  t0.external AS external_24,
  t0.source AS source_25,
  t0.source_code AS source_code_26,
  t0.cancellation_policy AS cancellation_policy_27,
  t0.commission AS commission_28,
  t0.main_image_id AS main_image_id_29,
  t0.hotel_type_id AS hotel_type_id_30,
  t0.zone_id AS zone_id_31,
  t0.address_id AS address_id_32
FROM
  hotel t0
WHERE
  t0.source = ?
  AND t0.source_code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.stars AS stars_3, t0.phone AS phone_4, t0.score AS score_5, t0.description AS description_6, t0.area_description AS area_description_7, t0.room_description AS room_description_8, t0.service_description AS service_description_9, t0.restaurant_description AS restaurant_description_10, t0.comments AS comments_11, t0.seo AS seo_12, t0.bookingConditions AS bookingConditions_13, t0.rooms AS rooms_14, t0.slug AS slug_15, t0.email AS email_16, t0.highlighted AS highlighted_17, t0.position AS position_18, t0.searchable AS searchable_19, t0.created AS created_20, t0.updated AS updated_21, t0.bond_instructions AS bond_instructions_22, t0.priority AS priority_23, t0.external AS external_24, t0.source AS source_25, t0.source_code AS source_code_26, t0.cancellation_policy AS cancellation_policy_27, t0.commission AS commission_28, t0.main_image_id AS main_image_id_29, t0.hotel_type_id AS hotel_type_id_30, t0.zone_id AS zone_id_31, t0.address_id AS address_id_32 FROM hotel t0 WHERE t0.source = 'TG#HPRG#20273' AND t0.source_code = 78359 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.stars AS stars_3,
  t0.phone AS phone_4,
  t0.score AS score_5,
  t0.description AS description_6,
  t0.area_description AS area_description_7,
  t0.room_description AS room_description_8,
  t0.service_description AS service_description_9,
  t0.restaurant_description AS restaurant_description_10,
  t0.comments AS comments_11,
  t0.seo AS seo_12,
  t0.bookingConditions AS bookingConditions_13,
  t0.rooms AS rooms_14,
  t0.slug AS slug_15,
  t0.email AS email_16,
  t0.highlighted AS highlighted_17,
  t0.position AS position_18,
  t0.searchable AS searchable_19,
  t0.created AS created_20,
  t0.updated AS updated_21,
  t0.bond_instructions AS bond_instructions_22,
  t0.priority AS priority_23,
  t0.external AS external_24,
  t0.source AS source_25,
  t0.source_code AS source_code_26,
  t0.cancellation_policy AS cancellation_policy_27,
  t0.commission AS commission_28,
  t0.main_image_id AS main_image_id_29,
  t0.hotel_type_id AS hotel_type_id_30,
  t0.zone_id AS zone_id_31,
  t0.address_id AS address_id_32
FROM
  hotel t0
WHERE
  t0.source = ?
  AND t0.source_code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.stars AS stars_3, t0.phone AS phone_4, t0.score AS score_5, t0.description AS description_6, t0.area_description AS area_description_7, t0.room_description AS room_description_8, t0.service_description AS service_description_9, t0.restaurant_description AS restaurant_description_10, t0.comments AS comments_11, t0.seo AS seo_12, t0.bookingConditions AS bookingConditions_13, t0.rooms AS rooms_14, t0.slug AS slug_15, t0.email AS email_16, t0.highlighted AS highlighted_17, t0.position AS position_18, t0.searchable AS searchable_19, t0.created AS created_20, t0.updated AS updated_21, t0.bond_instructions AS bond_instructions_22, t0.priority AS priority_23, t0.external AS external_24, t0.source AS source_25, t0.source_code AS source_code_26, t0.cancellation_policy AS cancellation_policy_27, t0.commission AS commission_28, t0.main_image_id AS main_image_id_29, t0.hotel_type_id AS hotel_type_id_30, t0.zone_id AS zone_id_31, t0.address_id AS address_id_32 FROM hotel t0 WHERE t0.source = 'TG#HPRG#20273' AND t0.source_code = 28847 LIMIT 1;