Symfony Profiler

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
WHERE
  t0.zone_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 WHERE t0.zone_id = 2536 AND t0.product_type IN ('product', 'ski', 'activity', 'pack');

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.slug = ?
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.slug = 'residence-pierre-vacances-le-christiana' 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 = ?
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.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 = 3014;

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
WHERE
  t0.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 WHERE t0.id = 2536;

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 = 1501
            AND r.date >= '2026-03-24'
            ORDER BY r.date ASC
            LIMIT 0,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;