Symfony Profiler

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.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 = 1408;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.iframe_youtube AS iframe_youtube_3,
  t0.iframe_vimeo AS iframe_vimeo_4,
  t0.latitude AS latitude_5,
  t0.longitude AS longitude_6,
  t0.description AS description_7,
  t0.airport_code AS airport_code_8,
  t0.destination_description AS destination_description_9,
  t0.page_description AS page_description_10,
  t0.parent_id AS parent_id_11,
  t12.id AS id_13,
  t12.slug AS slug_14,
  t12.type AS type_15,
  t12.meta_title AS meta_title_16,
  t12.meta_description AS meta_description_17,
  t12.meta_keyword AS meta_keyword_18,
  t12.status AS status_19,
  t12.redirect AS redirect_20,
  t12.redirect_code AS redirect_code_21,
  t12.marketing_campaign_id AS marketing_campaign_id_22,
  t12.hotel_destination_id AS hotel_destination_id_23,
  t12.hotel_category_id AS hotel_category_id_24,
  t12.hotel_id AS hotel_id_25,
  t12.tour_destination_id AS tour_destination_id_26,
  t12.tour_id AS tour_id_27,
  t12.tour_category_id AS tour_category_id_28,
  t12.tour_type_id AS tour_type_id_29,
  t12.landmark_id AS landmark_id_30,
  t12.destination_hotel_id AS destination_hotel_id_31,
  t12.tour_hotel_destination_id AS tour_hotel_destination_id_32,
  t12.tour_country_id AS tour_country_id_33,
  t12.hotel_page_destination_id AS hotel_page_destination_id_34,
  t0.image_id AS image_id_35,
  t36.id AS id_37,
  t36.slug AS slug_38,
  t36.type AS type_39,
  t36.meta_title AS meta_title_40,
  t36.meta_description AS meta_description_41,
  t36.meta_keyword AS meta_keyword_42,
  t36.status AS status_43,
  t36.redirect AS redirect_44,
  t36.redirect_code AS redirect_code_45,
  t36.marketing_campaign_id AS marketing_campaign_id_46,
  t36.hotel_destination_id AS hotel_destination_id_47,
  t36.hotel_category_id AS hotel_category_id_48,
  t36.hotel_id AS hotel_id_49,
  t36.tour_destination_id AS tour_destination_id_50,
  t36.tour_id AS tour_id_51,
  t36.tour_category_id AS tour_category_id_52,
  t36.tour_type_id AS tour_type_id_53,
  t36.landmark_id AS landmark_id_54,
  t36.destination_hotel_id AS destination_hotel_id_55,
  t36.tour_hotel_destination_id AS tour_hotel_destination_id_56,
  t36.tour_country_id AS tour_country_id_57,
  t36.hotel_page_destination_id AS hotel_page_destination_id_58
FROM
  hotel_destination t0
  LEFT JOIN seo_page t12 ON t12.hotel_destination_id = t0.id
  LEFT JOIN seo_page t36 ON t36.destination_hotel_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.iframe_youtube AS iframe_youtube_3, t0.iframe_vimeo AS iframe_vimeo_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.description AS description_7, t0.airport_code AS airport_code_8, t0.destination_description AS destination_description_9, t0.page_description AS page_description_10, t0.parent_id AS parent_id_11, t12.id AS id_13, t12.slug AS slug_14, t12.type AS type_15, t12.meta_title AS meta_title_16, t12.meta_description AS meta_description_17, t12.meta_keyword AS meta_keyword_18, t12.status AS status_19, t12.redirect AS redirect_20, t12.redirect_code AS redirect_code_21, t12.marketing_campaign_id AS marketing_campaign_id_22, t12.hotel_destination_id AS hotel_destination_id_23, t12.hotel_category_id AS hotel_category_id_24, t12.hotel_id AS hotel_id_25, t12.tour_destination_id AS tour_destination_id_26, t12.tour_id AS tour_id_27, t12.tour_category_id AS tour_category_id_28, t12.tour_type_id AS tour_type_id_29, t12.landmark_id AS landmark_id_30, t12.destination_hotel_id AS destination_hotel_id_31, t12.tour_hotel_destination_id AS tour_hotel_destination_id_32, t12.tour_country_id AS tour_country_id_33, t12.hotel_page_destination_id AS hotel_page_destination_id_34, t0.image_id AS image_id_35, t36.id AS id_37, t36.slug AS slug_38, t36.type AS type_39, t36.meta_title AS meta_title_40, t36.meta_description AS meta_description_41, t36.meta_keyword AS meta_keyword_42, t36.status AS status_43, t36.redirect AS redirect_44, t36.redirect_code AS redirect_code_45, t36.marketing_campaign_id AS marketing_campaign_id_46, t36.hotel_destination_id AS hotel_destination_id_47, t36.hotel_category_id AS hotel_category_id_48, t36.hotel_id AS hotel_id_49, t36.tour_destination_id AS tour_destination_id_50, t36.tour_id AS tour_id_51, t36.tour_category_id AS tour_category_id_52, t36.tour_type_id AS tour_type_id_53, t36.landmark_id AS landmark_id_54, t36.destination_hotel_id AS destination_hotel_id_55, t36.tour_hotel_destination_id AS tour_hotel_destination_id_56, t36.tour_country_id AS tour_country_id_57, t36.hotel_page_destination_id AS hotel_page_destination_id_58 FROM hotel_destination t0 LEFT JOIN seo_page t12 ON t12.hotel_destination_id = t0.id LEFT JOIN seo_page t36 ON t36.destination_hotel_id = t0.id WHERE t0.id = 24;

SELECT
  r0_.id AS id_0,
  r0_.total_price AS total_price_1,
  r0_.base_price AS base_price_2,
  r0_.base_cost AS base_cost_3,
  r0_.total_cost AS total_cost_4,
  r0_.currency AS currency_5,
  r0_.payed_price AS payed_price_6,
  r0_.remaining_price AS remaining_price_7,
  r0_.hotel_count AS hotel_count_8,
  r0_.flight_count AS flight_count_9,
  r0_.transfer_count AS transfer_count_10,
  r0_.tour_count AS tour_count_11,
  r0_.status AS status_12,
  r0_.created_at AS created_at_13,
  r0_.updated_at AS updated_at_14,
  r0_.adt_count AS adt_count_15,
  r0_.chd_count AS chd_count_16,
  r0_.check_in AS check_in_17,
  r0_.check_out AS check_out_18,
  r0_.voucher AS voucher_19,
  r0_.guest_note AS guest_note_20,
  r0_.approvel_status AS approvel_status_21,
  r0_.approvel_ip AS approvel_ip_22,
  r0_.eb_insurance_fee AS eb_insurance_fee_23,
  r0_.guid AS guid_24,
  r0_.guid_expiry AS guid_expiry_25,
  r0_.pakage_profit_percent AS pakage_profit_percent_26,
  r0_.pre_payment_rate AS pre_payment_rate_27,
  r0_.payment_transfer_no AS payment_transfer_no_28,
  r0_.notes AS notes_29,
  r0_.payment_transfer_name AS payment_transfer_name_30,
  r0_.agency_voucher_no AS agency_voucher_no_31,
  r0_.market AS market_32,
  r0_.active_pos_transaction_status AS active_pos_transaction_status_33,
  r0_.payment_type AS payment_type_34,
  r0_.deleted_at AS deleted_at_35,
  r0_.user_id AS user_id_36,
  r0_.discount_coupon_id AS discount_coupon_id_37,
  r0_.package_profit_id AS package_profit_id_38,
  r0_.operation_user_id AS operation_user_id_39,
  r0_.agency_id AS agency_id_40,
  r0_.kvkk_consent_contract_id AS kvkk_consent_contract_id_41,
  r0_.kvkk_lighting_contract_id AS kvkk_lighting_contract_id_42,
  r0_.consent_contract_id AS consent_contract_id_43,
  r0_.lighting_contract_id AS lighting_contract_id_44,
  r0_.campaign_lighting_id AS campaign_lighting_id_45,
  r0_.campaign_consent_id AS campaign_consent_id_46,
  r0_.bank_account_id AS bank_account_id_47,
  r0_.payment_transfer_approvel_user_id AS payment_transfer_approvel_user_id_48,
  r0_.hotel_profit_id AS hotel_profit_id_49,
  r0_.currency_rate_id AS currency_rate_id_50,
  r0_.tour_package_contract_id AS tour_package_contract_id_51,
  r0_.site_id AS site_id_52
FROM
  reservation r0_
WHERE
  (r0_.voucher = ?)
  AND (r0_.deleted_at IS NULL)

SELECT r0_.id AS id_0, r0_.total_price AS total_price_1, r0_.base_price AS base_price_2, r0_.base_cost AS base_cost_3, r0_.total_cost AS total_cost_4, r0_.currency AS currency_5, r0_.payed_price AS payed_price_6, r0_.remaining_price AS remaining_price_7, r0_.hotel_count AS hotel_count_8, r0_.flight_count AS flight_count_9, r0_.transfer_count AS transfer_count_10, r0_.tour_count AS tour_count_11, r0_.status AS status_12, r0_.created_at AS created_at_13, r0_.updated_at AS updated_at_14, r0_.adt_count AS adt_count_15, r0_.chd_count AS chd_count_16, r0_.check_in AS check_in_17, r0_.check_out AS check_out_18, r0_.voucher AS voucher_19, r0_.guest_note AS guest_note_20, r0_.approvel_status AS approvel_status_21, r0_.approvel_ip AS approvel_ip_22, r0_.eb_insurance_fee AS eb_insurance_fee_23, r0_.guid AS guid_24, r0_.guid_expiry AS guid_expiry_25, r0_.pakage_profit_percent AS pakage_profit_percent_26, r0_.pre_payment_rate AS pre_payment_rate_27, r0_.payment_transfer_no AS payment_transfer_no_28, r0_.notes AS notes_29, r0_.payment_transfer_name AS payment_transfer_name_30, r0_.agency_voucher_no AS agency_voucher_no_31, r0_.market AS market_32, r0_.active_pos_transaction_status AS active_pos_transaction_status_33, r0_.payment_type AS payment_type_34, r0_.deleted_at AS deleted_at_35, r0_.user_id AS user_id_36, r0_.discount_coupon_id AS discount_coupon_id_37, r0_.package_profit_id AS package_profit_id_38, r0_.operation_user_id AS operation_user_id_39, r0_.agency_id AS agency_id_40, r0_.kvkk_consent_contract_id AS kvkk_consent_contract_id_41, r0_.kvkk_lighting_contract_id AS kvkk_lighting_contract_id_42, r0_.consent_contract_id AS consent_contract_id_43, r0_.lighting_contract_id AS lighting_contract_id_44, r0_.campaign_lighting_id AS campaign_lighting_id_45, r0_.campaign_consent_id AS campaign_consent_id_46, r0_.bank_account_id AS bank_account_id_47, r0_.payment_transfer_approvel_user_id AS payment_transfer_approvel_user_id_48, r0_.hotel_profit_id AS hotel_profit_id_49, r0_.currency_rate_id AS currency_rate_id_50, r0_.tour_package_contract_id AS tour_package_contract_id_51, r0_.site_id AS site_id_52 FROM reservation r0_ WHERE (r0_.voucher = 'NYI2407097068') AND (r0_.deleted_at IS NULL);

SELECT
  t0.id AS id_1,
  t0.reservation_code AS reservation_code_2,
  t0.voucher AS voucher_3,
  t0.parent_reservation_code AS parent_reservation_code_4,
  t0.parent_voucher AS parent_voucher_5,
  t0.is_forwarded_flight AS is_forwarded_flight_6,
  t0.is_forwarded_hotel AS is_forwarded_hotel_7,
  t0.is_forwarded_transfer AS is_forwarded_transfer_8,
  t0.is_forwarded_payment AS is_forwarded_payment_9,
  t0.is_forwarded_pax AS is_forwarded_pax_10,
  t0.is_forwarded_payment_td AS is_forwarded_payment_td_11,
  t0.deleted_at AS deleted_at_12,
  t0.reservation_id AS reservation_id_13
FROM
  puzzle_reservation_forwarding t0
WHERE
  t0.reservation_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.reservation_code AS reservation_code_2, t0.voucher AS voucher_3, t0.parent_reservation_code AS parent_reservation_code_4, t0.parent_voucher AS parent_voucher_5, t0.is_forwarded_flight AS is_forwarded_flight_6, t0.is_forwarded_hotel AS is_forwarded_hotel_7, t0.is_forwarded_transfer AS is_forwarded_transfer_8, t0.is_forwarded_payment AS is_forwarded_payment_9, t0.is_forwarded_pax AS is_forwarded_pax_10, t0.is_forwarded_payment_td AS is_forwarded_payment_td_11, t0.deleted_at AS deleted_at_12, t0.reservation_id AS reservation_id_13 FROM puzzle_reservation_forwarding t0 WHERE t0.reservation_id = 66146 AND ((t0.deleted_at IS NULL));

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 = 'REVNVFVSOjE3MTcxNTk4OTY=' AND ((t0.deleted_at IS NULL)) LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.reservation_id AS reservation_id_3,
  t0.hotel_id AS hotel_id_4,
  t0.tour_id AS tour_id_5
FROM
  comment t0
WHERE
  t0.reservation_id = ?

SELECT t0.id AS id_1, t0.content AS content_2, t0.reservation_id AS reservation_id_3, t0.hotel_id AS hotel_id_4, t0.tour_id AS tour_id_5 FROM comment t0 WHERE t0.reservation_id = 66146;

SELECT
  h0_.id AS id_0
FROM
  hotel_eb_insurance h0_
  INNER JOIN eb_insurances_except_hotels e2_ ON h0_.id = e2_.eb_insurance_id
  INNER JOIN hotel h1_ ON h1_.id = e2_.hotel_id
  AND (
    h1_.id IN (?)
  )

SELECT h0_.id AS id_0 FROM hotel_eb_insurance h0_ INNER JOIN eb_insurances_except_hotels e2_ ON h0_.id = e2_.eb_insurance_id INNER JOIN hotel h1_ ON h1_.id = e2_.hotel_id AND (h1_.id IN (1383));

SELECT
  t0.id AS id_1,
  t0.is_recommend_by_td AS is_recommend_by_td_2,
  t0.name AS name_3,
  t0.status AS status_4,
  t0.provider_reference AS provider_reference_5,
  t0.star AS star_6,
  t0.mail AS mail_7,
  t0.phone AS phone_8,
  t0.fax AS fax_9,
  t0.address AS address_10,
  t0.latitude AS latitude_11,
  t0.longitude AS longitude_12,
  t0.puzzle_reference AS puzzle_reference_13,
  t0.passenger_reference AS passenger_reference_14,
  t0.oldtd_reference AS oldtd_reference_15,
  t0.trip_advisor_key AS trip_advisor_key_16,
  t0.trip_point AS trip_point_17,
  t0.is_valid_price AS is_valid_price_18,
  t0.puzzle_tranfer_area_code AS puzzle_tranfer_area_code_19,
  t0.provider_fetch_count AS provider_fetch_count_20,
  t0.shown AS shown_21,
  t0.passenger_transfer_area_code AS passenger_transfer_area_code_22,
  t0.provider_id AS provider_id_23,
  t0.destination_id AS destination_id_24,
  t25.id AS id_26,
  t25.slug AS slug_27,
  t25.type AS type_28,
  t25.meta_title AS meta_title_29,
  t25.meta_description AS meta_description_30,
  t25.meta_keyword AS meta_keyword_31,
  t25.status AS status_32,
  t25.redirect AS redirect_33,
  t25.redirect_code AS redirect_code_34,
  t25.marketing_campaign_id AS marketing_campaign_id_35,
  t25.hotel_destination_id AS hotel_destination_id_36,
  t25.hotel_category_id AS hotel_category_id_37,
  t25.hotel_id AS hotel_id_38,
  t25.tour_destination_id AS tour_destination_id_39,
  t25.tour_id AS tour_id_40,
  t25.tour_category_id AS tour_category_id_41,
  t25.tour_type_id AS tour_type_id_42,
  t25.landmark_id AS landmark_id_43,
  t25.destination_hotel_id AS destination_hotel_id_44,
  t25.tour_hotel_destination_id AS tour_hotel_destination_id_45,
  t25.tour_country_id AS tour_country_id_46,
  t25.hotel_page_destination_id AS hotel_page_destination_id_47,
  t0.image_id AS image_id_48
FROM
  hotel t0
  LEFT JOIN seo_page t25 ON t25.hotel_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.is_recommend_by_td AS is_recommend_by_td_2, t0.name AS name_3, t0.status AS status_4, t0.provider_reference AS provider_reference_5, t0.star AS star_6, t0.mail AS mail_7, t0.phone AS phone_8, t0.fax AS fax_9, t0.address AS address_10, t0.latitude AS latitude_11, t0.longitude AS longitude_12, t0.puzzle_reference AS puzzle_reference_13, t0.passenger_reference AS passenger_reference_14, t0.oldtd_reference AS oldtd_reference_15, t0.trip_advisor_key AS trip_advisor_key_16, t0.trip_point AS trip_point_17, t0.is_valid_price AS is_valid_price_18, t0.puzzle_tranfer_area_code AS puzzle_tranfer_area_code_19, t0.provider_fetch_count AS provider_fetch_count_20, t0.shown AS shown_21, t0.passenger_transfer_area_code AS passenger_transfer_area_code_22, t0.provider_id AS provider_id_23, t0.destination_id AS destination_id_24, t25.id AS id_26, t25.slug AS slug_27, t25.type AS type_28, t25.meta_title AS meta_title_29, t25.meta_description AS meta_description_30, t25.meta_keyword AS meta_keyword_31, t25.status AS status_32, t25.redirect AS redirect_33, t25.redirect_code AS redirect_code_34, t25.marketing_campaign_id AS marketing_campaign_id_35, t25.hotel_destination_id AS hotel_destination_id_36, t25.hotel_category_id AS hotel_category_id_37, t25.hotel_id AS hotel_id_38, t25.tour_destination_id AS tour_destination_id_39, t25.tour_id AS tour_id_40, t25.tour_category_id AS tour_category_id_41, t25.tour_type_id AS tour_type_id_42, t25.landmark_id AS landmark_id_43, t25.destination_hotel_id AS destination_hotel_id_44, t25.tour_hotel_destination_id AS tour_hotel_destination_id_45, t25.tour_country_id AS tour_country_id_46, t25.hotel_page_destination_id AS hotel_page_destination_id_47, t0.image_id AS image_id_48 FROM hotel t0 LEFT JOIN seo_page t25 ON t25.hotel_id = t0.id WHERE t0.id = 1383;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.gender AS gender_3,
  t0.first_name AS first_name_4,
  t0.last_name AS last_name_5,
  t0.birthday AS birthday_6,
  t0.phone AS phone_7,
  t0.hes_code AS hes_code_8,
  t0.identify_number AS identify_number_9,
  t0.passport_number AS passport_number_10,
  t0.age AS age_11,
  t0.puzzle_code AS puzzle_code_12,
  t0.passport_validity_date AS passport_validity_date_13,
  t0.deleted_at AS deleted_at_14,
  t0.reservation_id AS reservation_id_15,
  t16.id AS id_17,
  t16.refund_reservation_id AS refund_reservation_id_18,
  t16.reservation_pax_id AS reservation_pax_id_19
FROM
  reservation_pax t0
  LEFT JOIN refund_pax t16 ON t16.reservation_pax_id = t0.id
WHERE
  t0.reservation_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.type AS type_2, t0.gender AS gender_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.birthday AS birthday_6, t0.phone AS phone_7, t0.hes_code AS hes_code_8, t0.identify_number AS identify_number_9, t0.passport_number AS passport_number_10, t0.age AS age_11, t0.puzzle_code AS puzzle_code_12, t0.passport_validity_date AS passport_validity_date_13, t0.deleted_at AS deleted_at_14, t0.reservation_id AS reservation_id_15, t16.id AS id_17, t16.refund_reservation_id AS refund_reservation_id_18, t16.reservation_pax_id AS reservation_pax_id_19 FROM reservation_pax t0 LEFT JOIN refund_pax t16 ON t16.reservation_pax_id = t0.id WHERE t0.reservation_id = 66146 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.check_in AS check_in_2,
  t0.check_out AS check_out_3,
  t0.room_code AS room_code_4,
  t0.room_title AS room_title_5,
  t0.concept_code AS concept_code_6,
  t0.concept_title AS concept_title_7,
  t0.price AS price_8,
  t0.cost AS cost_9,
  t0.currency AS currency_10,
  t0.base_price AS base_price_11,
  t0.base_cost AS base_cost_12,
  t0.process AS process_13,
  t0.deleted_at AS deleted_at_14,
  t0.reservation_id AS reservation_id_15,
  t0.hotel_id AS hotel_id_16,
  t0.currency_rate_id AS currency_rate_id_17
FROM
  reservation_hotel t0
WHERE
  t0.reservation_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.check_in AS check_in_2, t0.check_out AS check_out_3, t0.room_code AS room_code_4, t0.room_title AS room_title_5, t0.concept_code AS concept_code_6, t0.concept_title AS concept_title_7, t0.price AS price_8, t0.cost AS cost_9, t0.currency AS currency_10, t0.base_price AS base_price_11, t0.base_cost AS base_cost_12, t0.process AS process_13, t0.deleted_at AS deleted_at_14, t0.reservation_id AS reservation_id_15, t0.hotel_id AS hotel_id_16, t0.currency_rate_id AS currency_rate_id_17 FROM reservation_hotel t0 WHERE t0.reservation_id = 66146 AND ((t0.deleted_at IS NULL));

SELECT
  p0_.id AS id_0,
  p0_.rate AS rate_1,
  p0_.last_day_valid AS last_day_valid_2,
  p0_.status AS status_3,
  p0_.hotel_destination_id AS hotel_destination_id_4,
  p0_.site_id AS site_id_5
FROM
  pre_payment_campaign p0_
WHERE
  p0_.status = ?
  AND p0_.hotel_destination_id IN (?)
  AND p0_.site_id = ?
LIMIT
  1

SELECT p0_.id AS id_0, p0_.rate AS rate_1, p0_.last_day_valid AS last_day_valid_2, p0_.status AS status_3, p0_.hotel_destination_id AS hotel_destination_id_4, p0_.site_id AS site_id_5 FROM pre_payment_campaign p0_ WHERE p0_.status = 1 AND p0_.hotel_destination_id IN (24, 8) AND p0_.site_id = 2 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.cost AS cost_3,
  t0.transfer_type AS transfer_type_4,
  t0.date AS date_5,
  t0.way AS way_6,
  t0.status AS status_7,
  t0.currency AS currency_8,
  t0.base_price AS base_price_9,
  t0.base_cost AS base_cost_10,
  t0.process AS process_11,
  t0.meet_transfer AS meet_transfer_12,
  t0.return_transfer AS return_transfer_13,
  t0.transfer_from AS transfer_from_14,
  t0.transfer_to AS transfer_to_15,
  t0.deleted_at AS deleted_at_16,
  t0.reservation_id AS reservation_id_17,
  t0.airport_id AS airport_id_18,
  t0.hotel_destination_id AS hotel_destination_id_19,
  t0.vehicle_group_id AS vehicle_group_id_20,
  t0.currency_rate_id AS currency_rate_id_21,
  t0.hotel_id AS hotel_id_22
FROM
  reservation_transfer t0
WHERE
  t0.reservation_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.price AS price_2, t0.cost AS cost_3, t0.transfer_type AS transfer_type_4, t0.date AS date_5, t0.way AS way_6, t0.status AS status_7, t0.currency AS currency_8, t0.base_price AS base_price_9, t0.base_cost AS base_cost_10, t0.process AS process_11, t0.meet_transfer AS meet_transfer_12, t0.return_transfer AS return_transfer_13, t0.transfer_from AS transfer_from_14, t0.transfer_to AS transfer_to_15, t0.deleted_at AS deleted_at_16, t0.reservation_id AS reservation_id_17, t0.airport_id AS airport_id_18, t0.hotel_destination_id AS hotel_destination_id_19, t0.vehicle_group_id AS vehicle_group_id_20, t0.currency_rate_id AS currency_rate_id_21, t0.hotel_id AS hotel_id_22 FROM reservation_transfer t0 WHERE t0.reservation_id = 66146 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.currency AS currency_3,
  t0.commission AS commission_4,
  t0.date AS date_5,
  t0.virman_code AS virman_code_6,
  t0.is_forwarding AS is_forwarding_7,
  t0.is_collection AS is_collection_8,
  t0.is_expense AS is_expense_9,
  t0.is_income AS is_income_10,
  t0.is_collection_refund AS is_collection_refund_11,
  t0.deleted_at AS deleted_at_12,
  t0.reservation_id AS reservation_id_13,
  t0.payment_id AS payment_id_14,
  t0.currency_rate_id AS currency_rate_id_15,
  t0.user_id AS user_id_16
FROM
  reservation_payment t0
WHERE
  t0.reservation_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.currency AS currency_3, t0.commission AS commission_4, t0.date AS date_5, t0.virman_code AS virman_code_6, t0.is_forwarding AS is_forwarding_7, t0.is_collection AS is_collection_8, t0.is_expense AS is_expense_9, t0.is_income AS is_income_10, t0.is_collection_refund AS is_collection_refund_11, t0.deleted_at AS deleted_at_12, t0.reservation_id AS reservation_id_13, t0.payment_id AS payment_id_14, t0.currency_rate_id AS currency_rate_id_15, t0.user_id AS user_id_16 FROM reservation_payment t0 WHERE t0.reservation_id = 66146 AND ((t0.deleted_at IS NULL));

SELECT
  p0_.id AS id_0,
  p0_.credit_card_count AS credit_card_count_1,
  p0_.type AS type_2,
  p0_.site_id AS site_id_3,
  p0_.payment_partial_id AS payment_partial_id_4
FROM
  payment_partial_setting p0_
  INNER JOIN payment_partial p1_ ON p0_.payment_partial_id = p1_.id
WHERE
  p1_.type = ?
  AND p0_.site_id = ?

SELECT p0_.id AS id_0, p0_.credit_card_count AS credit_card_count_1, p0_.type AS type_2, p0_.site_id AS site_id_3, p0_.payment_partial_id AS payment_partial_id_4 FROM payment_partial_setting p0_ INNER JOIN payment_partial p1_ ON p0_.payment_partial_id = p1_.id WHERE p1_.type = 'HOTEL' AND p0_.site_id = 2;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.locale AS locale_3,
  t0.payment_partial_setting_id AS payment_partial_setting_id_4
FROM
  payment_partial_setting_translation t0
WHERE
  t0.payment_partial_setting_id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.locale AS locale_3, t0.payment_partial_setting_id AS payment_partial_setting_id_4 FROM payment_partial_setting_translation t0 WHERE t0.payment_partial_setting_id = 2;

SELECT
  t0.id AS id_1,
  t0.provider_process_code AS provider_process_code_2,
  t0.airline_code AS airline_code_3,
  t0.ticket_date AS ticket_date_4,
  t0.flight_no AS flight_no_5,
  t0.type AS type_6,
  t0.departure_airport AS departure_airport_7,
  t0.arrival_airport AS arrival_airport_8,
  t0.departure_date AS departure_date_9,
  t0.departure_time AS departure_time_10,
  t0.arrival_date AS arrival_date_11,
  t0.arrival_time AS arrival_time_12,
  t0.status AS status_13,
  t0.is_cancelled AS is_cancelled_14,
  t0.pnr AS pnr_15,
  t0.price AS price_16,
  t0.cost AS cost_17,
  t0.currency AS currency_18,
  t0.base_price AS base_price_19,
  t0.base_cost AS base_cost_20,
  t0.process AS process_21,
  t0.class_type AS class_type_22,
  t0.deleted_at AS deleted_at_23,
  t0.reservation_id AS reservation_id_24,
  t0.currency_rate_id AS currency_rate_id_25
FROM
  reservation_flight t0
WHERE
  t0.reservation_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )