Symfony Profiler

SELECT
  s0_.id AS id_0,
  s0_.slug AS slug_1,
  s0_.type AS type_2,
  s0_.meta_title AS meta_title_3,
  s0_.meta_description AS meta_description_4,
  s0_.meta_keyword AS meta_keyword_5,
  s0_.status AS status_6,
  s0_.redirect AS redirect_7,
  s0_.redirect_code AS redirect_code_8,
  s0_.marketing_campaign_id AS marketing_campaign_id_9,
  s0_.hotel_destination_id AS hotel_destination_id_10,
  s0_.hotel_category_id AS hotel_category_id_11,
  s0_.hotel_id AS hotel_id_12,
  s0_.tour_destination_id AS tour_destination_id_13,
  s0_.tour_id AS tour_id_14,
  s0_.tour_category_id AS tour_category_id_15,
  s0_.tour_type_id AS tour_type_id_16,
  s0_.landmark_id AS landmark_id_17,
  s0_.destination_hotel_id AS destination_hotel_id_18,
  s0_.tour_hotel_destination_id AS tour_hotel_destination_id_19,
  s0_.tour_country_id AS tour_country_id_20,
  s0_.hotel_page_destination_id AS hotel_page_destination_id_21
FROM
  seo_page s0_
  LEFT JOIN seo_page_sites s1_ ON s0_.id = s1_.seo_page_id
WHERE
  s0_.status = 1
  AND s1_.slug = ?
  AND s1_.site_id = ?
LIMIT
  1

SELECT s0_.id AS id_0, s0_.slug AS slug_1, s0_.type AS type_2, s0_.meta_title AS meta_title_3, s0_.meta_description AS meta_description_4, s0_.meta_keyword AS meta_keyword_5, s0_.status AS status_6, s0_.redirect AS redirect_7, s0_.redirect_code AS redirect_code_8, s0_.marketing_campaign_id AS marketing_campaign_id_9, s0_.hotel_destination_id AS hotel_destination_id_10, s0_.hotel_category_id AS hotel_category_id_11, s0_.hotel_id AS hotel_id_12, s0_.tour_destination_id AS tour_destination_id_13, s0_.tour_id AS tour_id_14, s0_.tour_category_id AS tour_category_id_15, s0_.tour_type_id AS tour_type_id_16, s0_.landmark_id AS landmark_id_17, s0_.destination_hotel_id AS destination_hotel_id_18, s0_.tour_hotel_destination_id AS tour_hotel_destination_id_19, s0_.tour_country_id AS tour_country_id_20, s0_.hotel_page_destination_id AS hotel_page_destination_id_21 FROM seo_page s0_ LEFT JOIN seo_page_sites s1_ ON s0_.id = s1_.seo_page_id WHERE s0_.status = 1 AND s1_.slug = '/' AND s1_.site_id = 2 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.logo_white AS logo_white_3,
  t0.logo AS logo_4,
  t0.is_edit AS is_edit_5,
  t0.mail_logo AS mail_logo_6,
  t0.mail_logo_background AS mail_logo_background_7,
  t0.site_address AS site_address_8,
  t0.phone AS phone_9,
  t0.mail AS mail_10,
  t0.address AS address_11,
  t0.panel_site_address AS panel_site_address_12,
  t0.language AS language_13,
  t0.is_domestic_hotel AS is_domestic_hotel_14,
  t0.is_abroad_hotel AS is_abroad_hotel_15,
  t0.is_cyprus_hotel AS is_cyprus_hotel_16,
  t0.is_domestic_tour AS is_domestic_tour_17,
  t0.is_abroad_tour AS is_abroad_tour_18,
  t0.is_domestic_flight AS is_domestic_flight_19,
  t0.is_abroad_flight AS is_abroad_flight_20,
  t0.is_domestic_transfer AS is_domestic_transfer_21,
  t0.is_abroad_transfer AS is_abroad_transfer_22,
  t0.noreply_mail AS noreply_mail_23,
  t0.user_id AS user_id_24
FROM
  sites t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.logo_white AS logo_white_3, t0.logo AS logo_4, t0.is_edit AS is_edit_5, t0.mail_logo AS mail_logo_6, t0.mail_logo_background AS mail_logo_background_7, t0.site_address AS site_address_8, t0.phone AS phone_9, t0.mail AS mail_10, t0.address AS address_11, t0.panel_site_address AS panel_site_address_12, t0.language AS language_13, t0.is_domestic_hotel AS is_domestic_hotel_14, t0.is_abroad_hotel AS is_abroad_hotel_15, t0.is_cyprus_hotel AS is_cyprus_hotel_16, t0.is_domestic_tour AS is_domestic_tour_17, t0.is_abroad_tour AS is_abroad_tour_18, t0.is_domestic_flight AS is_domestic_flight_19, t0.is_abroad_flight AS is_abroad_flight_20, t0.is_domestic_transfer AS is_domestic_transfer_21, t0.is_abroad_transfer AS is_abroad_transfer_22, t0.noreply_mail AS noreply_mail_23, t0.user_id AS user_id_24 FROM sites t0 WHERE t0.name = 'PUZZLEBOOKING' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.firstname AS firstname_5,
  t0.lastname AS lastname_6,
  t0.status AS status_7,
  t0.type AS type_8,
  t0.phone AS phone_9,
  t0.address AS address_10,
  t0.api_token AS api_token_11,
  t0.last_login_date AS last_login_date_12,
  t0.puzzle_code AS puzzle_code_13,
  t0.deleted_at AS deleted_at_14,
  t0.agency_id AS agency_id_15,
  t0.lighting_contract_id AS lighting_contract_id_16,
  t0.consent_contract_id AS consent_contract_id_17,
  t0.register_message_contract_id AS register_message_contract_id_18,
  t0.register_phone_contract_id AS register_phone_contract_id_19,
  t0.register_email_contract_id AS register_email_contract_id_20
FROM
  user t0
WHERE
  t0.api_token = ?
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.status AS status_7, t0.type AS type_8, t0.phone AS phone_9, t0.address AS address_10, t0.api_token AS api_token_11, t0.last_login_date AS last_login_date_12, t0.puzzle_code AS puzzle_code_13, t0.deleted_at AS deleted_at_14, t0.agency_id AS agency_id_15, t0.lighting_contract_id AS lighting_contract_id_16, t0.consent_contract_id AS consent_contract_id_17, t0.register_message_contract_id AS register_message_contract_id_18, t0.register_phone_contract_id AS register_phone_contract_id_19, t0.register_email_contract_id AS register_email_contract_id_20 FROM user t0 WHERE t0.api_token = 'QUxCQVRST1M6MTcyMDE3NTAyNA==' AND ((t0.deleted_at IS NULL)) LIMIT 1;

SELECT
  d0_.id AS id_0,
  d0_.code AS code_1,
  d0_.limit_count AS limit_count_2,
  d0_.remaining_count AS remaining_count_3,
  d0_.discount_id AS discount_id_4
FROM
  discount_coupons d0_
  LEFT JOIN discount d1_ ON d0_.discount_id = d1_.id
  LEFT JOIN discount_agency d3_ ON d1_.id = d3_.discount_id
  LEFT JOIN agency a2_ ON a2_.id = d3_.agency_id
  AND (a2_.deleted_at IS NULL)
WHERE
  d1_.status = 1
  AND d1_.popup_seo_url_id = ?
  AND d0_.remaining_count > ?
  AND (
    a2_.id IS NULL
    OR a2_.id NOT IN (?)
  )
  AND d1_.site_id = ?
LIMIT
  1

SELECT d0_.id AS id_0, d0_.code AS code_1, d0_.limit_count AS limit_count_2, d0_.remaining_count AS remaining_count_3, d0_.discount_id AS discount_id_4 FROM discount_coupons d0_ LEFT JOIN discount d1_ ON d0_.discount_id = d1_.id LEFT JOIN discount_agency d3_ ON d1_.id = d3_.discount_id LEFT JOIN agency a2_ ON a2_.id = d3_.agency_id AND (a2_.deleted_at IS NULL) WHERE d1_.status = 1 AND d1_.popup_seo_url_id = 14830 AND d0_.remaining_count > 0 AND (a2_.id IS NULL OR a2_.id NOT IN (78)) AND d1_.site_id = 2 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.tour_type_id AS tour_type_id_2,
  t0.seo_page_id AS seo_page_id_3,
  t4.id AS id_5,
  t4.type AS type_6,
  t4.aspect_ratio AS aspect_ratio_7,
  t4.full_path AS full_path_8,
  t4.width AS width_9,
  t4.height AS height_10,
  t4.mime AS mime_11,
  t4.row AS row_12,
  t4.title AS title_13,
  t4.description AS description_14,
  t4.bucket AS bucket_15,
  t4.path AS path_16,
  t4.size AS size_17,
  t4.oldtd_reference AS oldtd_reference_18,
  t4.hotel_type AS hotel_type_19,
  t4.line AS line_20,
  t4.tour_type_label_id AS tour_type_label_id_21,
  t4.hotel_id AS hotel_id_22,
  t4.tour_id AS tour_id_23,
  t4.hotel_event_id AS hotel_event_id_24,
  t4.marketing_campaign_id AS marketing_campaign_id_25,
  t4.hotel_destination_id AS hotel_destination_id_26,
  t4.landmark_id AS landmark_id_27,
  t4.tour_destination_id AS tour_destination_id_28,
  t4.hotel_hotel_room_id AS hotel_hotel_room_id_29,
  t4.cover_image_hotel_category_id AS cover_image_hotel_category_id_30,
  t4.banner_area_id AS banner_area_id_31,
  t4.hotel_category_id AS hotel_category_id_32,
  t4.cover_image_seo_page_id AS cover_image_seo_page_id_33,
  t4.hotel_image_type_id AS hotel_image_type_id_34,
  t4.agency_id AS agency_id_35
FROM
  tour_type_label t0
  LEFT JOIN image t4 ON t4.tour_type_label_id = t0.id
WHERE
  t0.seo_page_id = ?

SELECT t0.id AS id_1, t0.tour_type_id AS tour_type_id_2, t0.seo_page_id AS seo_page_id_3, t4.id AS id_5, t4.type AS type_6, t4.aspect_ratio AS aspect_ratio_7, t4.full_path AS full_path_8, t4.width AS width_9, t4.height AS height_10, t4.mime AS mime_11, t4.row AS row_12, t4.title AS title_13, t4.description AS description_14, t4.bucket AS bucket_15, t4.path AS path_16, t4.size AS size_17, t4.oldtd_reference AS oldtd_reference_18, t4.hotel_type AS hotel_type_19, t4.line AS line_20, t4.tour_type_label_id AS tour_type_label_id_21, t4.hotel_id AS hotel_id_22, t4.tour_id AS tour_id_23, t4.hotel_event_id AS hotel_event_id_24, t4.marketing_campaign_id AS marketing_campaign_id_25, t4.hotel_destination_id AS hotel_destination_id_26, t4.landmark_id AS landmark_id_27, t4.tour_destination_id AS tour_destination_id_28, t4.hotel_hotel_room_id AS hotel_hotel_room_id_29, t4.cover_image_hotel_category_id AS cover_image_hotel_category_id_30, t4.banner_area_id AS banner_area_id_31, t4.hotel_category_id AS hotel_category_id_32, t4.cover_image_seo_page_id AS cover_image_seo_page_id_33, t4.hotel_image_type_id AS hotel_image_type_id_34, t4.agency_id AS agency_id_35 FROM tour_type_label t0 LEFT JOIN image t4 ON t4.tour_type_label_id = t0.id WHERE t0.seo_page_id = 14830;

SELECT
  h0_.id AS id_0,
  h0_.min_acc AS min_acc_1,
  h0_.reservation_start_date AS reservation_start_date_2,
  h0_.reservation_end_date AS reservation_end_date_3,
  h0_.acc_start_date AS acc_start_date_4,
  h0_.acc_end_date AS acc_end_date_5,
  h0_.discount_rate AS discount_rate_6,
  h0_.discount_type AS discount_type_7,
  h0_.sequence AS sequence_8,
  h0_.status AS status_9,
  h0_.description AS description_10,
  h0_.direction AS direction_11,
  h0_.cost_affect AS cost_affect_12,
  h0_.discount_bracket AS discount_bracket_13,
  h0_.hotel_id AS hotel_id_14,
  h0_.destination_id AS destination_id_15,
  h0_.site_id AS site_id_16,
  h0_.tour_id AS tour_id_17,
  h0_.tour_category_id AS tour_category_id_18
FROM
  hotel_minute_deals h0_
WHERE
  h0_.status = ?
  AND h0_.reservation_start_date <= ?
  AND h0_.reservation_end_date >= ?
  AND h0_.site_id = ?
ORDER BY
  h0_.sequence DESC

SELECT h0_.id AS id_0, h0_.min_acc AS min_acc_1, h0_.reservation_start_date AS reservation_start_date_2, h0_.reservation_end_date AS reservation_end_date_3, h0_.acc_start_date AS acc_start_date_4, h0_.acc_end_date AS acc_end_date_5, h0_.discount_rate AS discount_rate_6, h0_.discount_type AS discount_type_7, h0_.sequence AS sequence_8, h0_.status AS status_9, h0_.description AS description_10, h0_.direction AS direction_11, h0_.cost_affect AS cost_affect_12, h0_.discount_bracket AS discount_bracket_13, h0_.hotel_id AS hotel_id_14, h0_.destination_id AS destination_id_15, h0_.site_id AS site_id_16, h0_.tour_id AS tour_id_17, h0_.tour_category_id AS tour_category_id_18 FROM hotel_minute_deals h0_ WHERE h0_.status = 1 AND h0_.reservation_start_date <= '2024-09-21 16:54:47' AND h0_.reservation_end_date >= '2024-09-21 16:54:47' AND h0_.site_id = 2 ORDER BY h0_.sequence DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.status AS status_3,
  t0.puzzle_code AS puzzle_code_4,
  t0.fax AS fax_5,
  t0.phone AS phone_6,
  t0.address AS address_7,
  t0.payment_type AS payment_type_8,
  t0.email AS email_9,
  t0.vat_office AS vat_office_10,
  t0.vat_number AS vat_number_11,
  t0.document_voucher AS document_voucher_12,
  t0.credit_amount AS credit_amount_13,
  t0.credit_cur AS credit_cur_14,
  t0.agency_rate AS agency_rate_15,
  t0.agency_package_tour_program_rate AS agency_package_tour_program_rate_16,
  t0.deleted_at AS deleted_at_17,
  t0.site_id AS site_id_18
FROM
  agency t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.puzzle_code AS puzzle_code_4, t0.fax AS fax_5, t0.phone AS phone_6, t0.address AS address_7, t0.payment_type AS payment_type_8, t0.email AS email_9, t0.vat_office AS vat_office_10, t0.vat_number AS vat_number_11, t0.document_voucher AS document_voucher_12, t0.credit_amount AS credit_amount_13, t0.credit_cur AS credit_cur_14, t0.agency_rate AS agency_rate_15, t0.agency_package_tour_program_rate AS agency_package_tour_program_rate_16, t0.deleted_at AS deleted_at_17, t0.site_id AS site_id_18 FROM agency t0 WHERE t0.id = 78 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.product AS product_2,
  t0.type AS type_3,
  t0.agency_id AS agency_id_4
FROM
  agency_product t0
WHERE
  t0.agency_id = ?

SELECT t0.id AS id_1, t0.product AS product_2, t0.type AS type_3, t0.agency_id AS agency_id_4 FROM agency_product t0 WHERE t0.agency_id = 78;