Query Metrics
46
Database Queries
26
Different statements
39.89 ms
Query time
24
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.82 ms |
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
Parameters:
[
"REVNVFVSOjE3MTcxNTk4OTY="
]
|
2 | 0.94 ms |
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
Parameters:
[
"PUZZLEBOOKING"
]
|
3 | 0.76 ms |
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))
Parameters:
[
48
]
|
4 | 0.78 ms |
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
Parameters:
[
"PUZZLEBOOKING"
]
|
5 | 0.75 ms |
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
Parameters:
[
"PUZZLEBOOKING"
]
|
6 | 0.78 ms |
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
Parameters:
[
"PUZZLEBOOKING"
]
|
7 | 0.70 ms |
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
Parameters:
[
"PUZZLEBOOKING"
]
|
8 | 1.22 ms |
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)
Parameters:
[
"NYI2407097068"
]
|
9 | 0.81 ms |
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 = ?
Parameters:
[
66146
]
|
10 | 1.08 ms |
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))
Parameters:
[
66146
]
|
11 | 1.00 ms |
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)
Parameters:
[
"NYI2407097068"
]
|
12 | 0.64 ms |
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 = ?
Parameters:
[
66146
]
|
13 | 0.79 ms |
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))
Parameters:
[
66146
]
|
14 | 0.74 ms |
SELECT t0.id AS id_1, t0.check_in AS check_in_2, t0.check_out AS check_out_3, t0.price AS price_4, t0.cost AS cost_5, t0.currency AS currency_6, t0.base_price AS base_price_7, t0.base_cost AS base_cost_8, t0.process AS process_9, t0.agency_cost AS agency_cost_10, t0.deleted_at AS deleted_at_11, t0.reservation_id AS reservation_id_12, t0.tour_id AS tour_id_13, t0.tour_price_id AS tour_price_id_14, t0.currency_rate_id AS currency_rate_id_15 FROM reservation_tour t0 WHERE t0.reservation_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
66146
]
|
15 | 0.84 ms |
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))
Parameters:
[
66146
]
|
16 | 0.77 ms |
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))
Parameters:
[
66146
]
|
17 | 0.68 ms |
SELECT t0.id AS id_1, t0.try AS try_2, t0.usd AS usd_3, t0.eur AS eur_4, t0.stg AS stg_5, t0.type AS type_6, t0.date AS date_7 FROM currency_rate t0 WHERE t0.id = ?
Parameters:
[
1051
]
|
18 | 0.84 ms |
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))
Parameters:
[
66146
]
|
19 | 0.69 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.price AS price_4, t0.cost AS cost_5, t0.base_price AS base_price_6, t0.base_cost AS base_cost_7, t0.currency AS currency_8, t0.type AS type_9, t0.icluded_price AS icluded_price_10, t0.extra_code AS extra_code_11, t0.optional_status AS optional_status_12, t0.reservation_id AS reservation_id_13, t0.currency_rate_id AS currency_rate_id_14 FROM reservation_hotel_extra t0 WHERE t0.reservation_id = ?
Parameters:
[
66146
]
|
20 | 0.99 ms |
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 (?))
Parameters:
[
[
1383
]
]
|
21 | 0.76 ms |
SELECT h0_.id AS id_0, h0_.min_price AS min_price_1, h0_.max_price AS max_price_2, h0_.percentage AS percentage_3, h0_.currency AS currency_4, h0_.market_name AS market_name_5, h0_.code AS code_6, h0_.provider AS provider_7, h0_.fee AS fee_8 FROM hotel_eb_insurance h0_ WHERE h0_.provider <= ? AND h0_.max_price >= ? AND h0_.min_price <= ? AND h0_.currency <= ?
Parameters:
[ "PZ" 69937.5 69937.5 "TRY" ] |
22 | 0.92 ms |
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 = ?
Parameters:
[
1383
]
|
23 | 0.86 ms |
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 = ?
Parameters:
[
1408
]
|
24 | 0.70 ms |
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
Parameters:
[
"PUZZLEBOOKING"
]
|
25 | 0.74 ms |
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
Parameters:
[
"PUZZLEBOOKING"
]
|
26 | 0.67 ms |
SELECT t0.id AS id_1, t0.tourism_business_certificate AS tourism_business_certificate_2, t0.partial_tourism_business_certificate AS partial_tourism_business_certificate_3, t0.tourism_investment_certificate AS tourism_investment_certificate_4, t0.simple_accommodation AS simple_accommodation_5, t0.beach_management AS beach_management_6, t0.site_id AS site_id_7, t0.hotel_id AS hotel_id_8 FROM hotel_site t0 WHERE t0.hotel_id = ?
Parameters:
[
1383
]
|
27 | 0.68 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.address AS address_4, t0.youtube_iframe AS youtube_iframe_5, t0.hotel_site_id AS hotel_site_id_6 FROM hotel_site_translation t0 WHERE t0.hotel_site_id = ?
Parameters:
[
3077
]
|
28 | 1.20 ms |
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 = ?
Parameters:
[
24
]
|
29 | 0.84 ms |
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 = ?
Parameters:
[
1396
]
|
30 | 0.74 ms |
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
Parameters:
[
"PUZZLEBOOKING"
]
|
31 | 0.79 ms |
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 = ?
Parameters:
[
12653
]
|
32 | 0.70 ms |
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
Parameters:
[
"PUZZLEBOOKING"
]
|
33 | 0.72 ms |
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
Parameters:
[
"PUZZLEBOOKING"
]
|
34 | 0.75 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.aspect_ratio AS aspect_ratio_3, t0.full_path AS full_path_4, t0.width AS width_5, t0.height AS height_6, t0.mime AS mime_7, t0.row AS row_8, t0.title AS title_9, t0.description AS description_10, t0.bucket AS bucket_11, t0.path AS path_12, t0.size AS size_13, t0.oldtd_reference AS oldtd_reference_14, t0.hotel_type AS hotel_type_15, t0.line AS line_16, t0.tour_type_label_id AS tour_type_label_id_17, t0.hotel_id AS hotel_id_18, t0.tour_id AS tour_id_19, t0.hotel_event_id AS hotel_event_id_20, t0.marketing_campaign_id AS marketing_campaign_id_21, t0.hotel_destination_id AS hotel_destination_id_22, t0.landmark_id AS landmark_id_23, t0.tour_destination_id AS tour_destination_id_24, t0.hotel_hotel_room_id AS hotel_hotel_room_id_25, t0.cover_image_hotel_category_id AS cover_image_hotel_category_id_26, t0.banner_area_id AS banner_area_id_27, t0.hotel_category_id AS hotel_category_id_28, t0.cover_image_seo_page_id AS cover_image_seo_page_id_29, t0.hotel_image_type_id AS hotel_image_type_id_30, t0.agency_id AS agency_id_31 FROM image t0 WHERE t0.id = ?
Parameters:
[
55056
]
|
35 | 1.75 ms |
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 = ?
Parameters:
[
8
]
|
36 | 0.82 ms |
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 = ?
Parameters:
[
3004
]
|
37 | 0.85 ms |
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
Parameters:
[
"PUZZLEBOOKING"
]
|
38 | 1.26 ms |
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 = ?
Parameters:
[
12647
]
|
39 | 0.93 ms |
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
Parameters:
[
"PUZZLEBOOKING"
]
|
40 | 0.71 ms |
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
Parameters:
[
"PUZZLEBOOKING"
]
|
41 | 0.86 ms |
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))
Parameters:
[
66146
]
|
42 | 0.83 ms |
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))
Parameters:
[
66146
]
|
43 | 0.76 ms |
SELECT t0.id AS id_1, t0.invoice_type AS invoice_type_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.company_name AS company_name_5, t0.email AS email_6, t0.identify_number AS identify_number_7, t0.tax_office AS tax_office_8, t0.tax_number AS tax_number_9, t0.status AS status_10, t0.address AS address_11, t0.phone AS phone_12, t0.deleted_at AS deleted_at_13, t0.reservation_id AS reservation_id_14, t0.city_id AS city_id_15, t0.district_id AS district_id_16 FROM reservation_invoice t0 WHERE t0.reservation_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
66146
]
|
44 | 0.84 ms |
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
Parameters:
[ 1 [ 24 8 ] 2 ] |
45 | 0.80 ms |
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 = ?
Parameters:
[ "HOTEL" 2 ] |
46 | 0.80 ms |
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 = ?
Parameters:
[
2
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\User |
|
App\Entity\Agency | No errors. |
App\Entity\Contract | No errors. |
App\Entity\SearchLogHotel |
|
App\Entity\Reservation |
|
App\Entity\PuzzleForwardingLogs | No errors. |
App\Entity\Refund | No errors. |
App\Entity\Sites | No errors. |
App\Entity\Hotel |
|
App\Entity\Tour |
|
App\Entity\HotelDestination |
|
App\Entity\TourDestination |
|
App\Entity\Landmarks | No errors. |
App\Entity\BankAccount | No errors. |
App\Entity\SeoMenuCategory | No errors. |
App\Entity\LogoAccountingCode | No errors. |
App\Entity\HotelMinuteDeals | No errors. |
App\Entity\PrePaymentCampaign |
|
App\Entity\MarketingCampaign |
|
App\Entity\PaymentPartialSetting | No errors. |
App\Entity\PackageProfit | No errors. |
App\Entity\SearchSuggestion | No errors. |
App\Entity\BannerArea | No errors. |
App\Entity\Request | No errors. |
App\Entity\SeoPageSites | No errors. |
App\Entity\HotelSite | No errors. |
App\Entity\TourSite | No errors. |
App\Entity\HotelDestinationSite | No errors. |
App\Entity\HotelCategorySite | No errors. |
App\Entity\TourDestinationSite | No errors. |
App\Entity\PosInstallment | No errors. |
App\Entity\Discount | No errors. |
App\Entity\Image |
|
App\Entity\AgencyProduct | No errors. |
App\Entity\ReservationInvoice |
|
App\Entity\HotelEbInsurance | No errors. |
App\Entity\Airport |
|
App\Entity\CurrencyRate |
|
App\Entity\Review |
|
App\Entity\ReservationFlight | No errors. |
App\Entity\ReservationHotel |
|
App\Entity\ReservationTransfer | No errors. |
App\Entity\ReservationTour | No errors. |
App\Entity\ReservationPax | No errors. |
App\Entity\ReservationPayment | No errors. |
App\Entity\Pos | No errors. |
App\Entity\DiscountCoupons | No errors. |
App\Entity\ReservationConversion | No errors. |
App\Entity\City | No errors. |
App\Entity\District | No errors. |
App\Entity\HotelProfit | No errors. |
App\Entity\Voucher | No errors. |
App\Entity\AvailableHotelRoomPrice |
|
App\Entity\HotelRoomImage | No errors. |
App\Entity\HotelRoomFeatsheet | No errors. |
App\Entity\Comment | No errors. |
App\Entity\PuzzleReservationForwarding | No errors. |
App\Entity\Payment |
|
App\Entity\ReservationTourExtra | No errors. |
App\Entity\ReservationLogo | No errors. |
App\Entity\ReservationDayPrice | No errors. |
App\Entity\ReservationHotelExtra |
|
App\Entity\TourPrice | No errors. |
App\Entity\TransferVehicleGroup | No errors. |
App\Entity\HotelProvider | No errors. |
App\Entity\SeoPage |
|
App\Entity\HotelCategory |
|
App\Entity\TourCategory |
|
App\Entity\TourType | No errors. |
App\Entity\TourCountry | No errors. |
App\Entity\HotelFacality | No errors. |
App\Entity\HotelEvent | No errors. |
App\Entity\HotelInstallment | No errors. |
App\Entity\DiscountHotel | No errors. |
App\Entity\HotelHotelCategory | No errors. |
App\Entity\HotelHotelDestination | No errors. |
App\Entity\HotelConcept | No errors. |
App\Entity\HotelHotelRoom | No errors. |
App\Entity\LandmarksHotelHotel | No errors. |
App\Entity\HotelRoomProvider | No errors. |
App\Entity\HotelTranslation | No errors. |
App\Entity\HotelCommission | No errors. |
App\Entity\SeoPageArticle | No errors. |
App\Entity\SeoMenu | No errors. |
App\Entity\FAQCategory |
|
App\Entity\TourTypeLabel |
|
App\Entity\HotelImageType | No errors. |
App\Entity\SeoPageTranslation | No errors. |
App\Entity\HotelSiteTranslation | No errors. |
App\Entity\Transfer | No errors. |
App\Entity\DiscountHotelDestination | No errors. |
App\Entity\LandmarksHotelDestination | No errors. |
App\Entity\HotelDestinationTranslation | No errors. |
App\Entity\RefundPax |
|
App\Entity\RefundReservation | No errors. |
App\Entity\ReservationFlightTicket | No errors. |
App\Entity\PaymentPartial | No errors. |
App\Entity\PaymentPartialSettingTranslation | No errors. |