Query Metrics
51
Database Queries
28
Different statements
208.57 ms
Query time
24
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
90.94 ms (43.60%) |
5 |
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:
[
1522
]
|
35.74 ms (17.14%) |
1 |
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:
[
1493
]
|
15.23 ms (7.30%) |
13 |
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"
]
|
10.46 ms (5.02%) |
4 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4, t0.iata_code AS iata_code_5 FROM airport t0 WHERE t0.iata_code = ? LIMIT 1
Parameters:
[
"SAW"
]
|
7.79 ms (3.74%) |
2 |
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:
[
21
]
|
6.99 ms (3.35%) |
1 |
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:
[
1493
]
|
4.39 ms (2.11%) |
1 |
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:
[
[
1493
]
]
|
4.36 ms (2.09%) |
2 |
SELECT t0.id AS id_1, t0.class AS class_2, t0.airline_code AS airline_code_3, t0.flight_no AS flight_no_4, t0.departure_airport AS departure_airport_5, t0.arrival_airport AS arrival_airport_6, t0.departure_date AS departure_date_7, t0.departure_time AS departure_time_8, t0.arrival_date AS arrival_date_9, t0.arrival_time AS arrival_time_10, t0.deleted_at AS deleted_at_11, t0.reservation_flight_id AS reservation_flight_id_12 FROM reservation_flight_segment t0 WHERE t0.reservation_flight_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
83287
]
|
3.60 ms (1.73%) |
1 |
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:
[
1337
]
|
3.26 ms (1.56%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.locale AS locale_4, t0.airport_id AS airport_id_5 FROM airport_translation t0 WHERE t0.airport_id = ?
Parameters:
[
186
]
|
2.70 ms (1.29%) |
1 |
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:
[
82988
]
|
2.64 ms (1.27%) |
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
Parameters:
[
"R1JVUEFOWUEuOjE3MjM1MzU4Njg="
]
|
2.42 ms (1.16%) |
2 |
SELECT t0.id AS id_1, t0.total_price AS total_price_2, t0.base_price AS base_price_3, t0.base_cost AS base_cost_4, t0.total_cost AS total_cost_5, t0.currency AS currency_6, t0.payed_price AS payed_price_7, t0.remaining_price AS remaining_price_8, t0.hotel_count AS hotel_count_9, t0.flight_count AS flight_count_10, t0.transfer_count AS transfer_count_11, t0.tour_count AS tour_count_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.adt_count AS adt_count_16, t0.chd_count AS chd_count_17, t0.check_in AS check_in_18, t0.check_out AS check_out_19, t0.voucher AS voucher_20, t0.guest_note AS guest_note_21, t0.approvel_status AS approvel_status_22, t0.approvel_ip AS approvel_ip_23, t0.eb_insurance_fee AS eb_insurance_fee_24, t0.guid AS guid_25, t0.guid_expiry AS guid_expiry_26, t0.pakage_profit_percent AS pakage_profit_percent_27, t0.pre_payment_rate AS pre_payment_rate_28, t0.payment_transfer_no AS payment_transfer_no_29, t0.notes AS notes_30, t0.payment_transfer_name AS payment_transfer_name_31, t0.agency_voucher_no AS agency_voucher_no_32, t0.market AS market_33, t0.active_pos_transaction_status AS active_pos_transaction_status_34, t0.payment_type AS payment_type_35, t0.deleted_at AS deleted_at_36, t37.id AS id_38, t37.content AS content_39, t37.reservation_id AS reservation_id_40, t37.hotel_id AS hotel_id_41, t37.tour_id AS tour_id_42, t43.id AS id_44, t43.reservation_code AS reservation_code_45, t43.voucher AS voucher_46, t43.parent_reservation_code AS parent_reservation_code_47, t43.parent_voucher AS parent_voucher_48, t43.is_forwarded_flight AS is_forwarded_flight_49, t43.is_forwarded_hotel AS is_forwarded_hotel_50, t43.is_forwarded_transfer AS is_forwarded_transfer_51, t43.is_forwarded_payment AS is_forwarded_payment_52, t43.is_forwarded_pax AS is_forwarded_pax_53, t43.is_forwarded_payment_td AS is_forwarded_payment_td_54, t43.deleted_at AS deleted_at_55, t43.reservation_id AS reservation_id_56, t0.user_id AS user_id_57, t0.discount_coupon_id AS discount_coupon_id_58, t0.package_profit_id AS package_profit_id_59, t0.operation_user_id AS operation_user_id_60, t0.agency_id AS agency_id_61, t0.kvkk_consent_contract_id AS kvkk_consent_contract_id_62, t0.kvkk_lighting_contract_id AS kvkk_lighting_contract_id_63, t0.consent_contract_id AS consent_contract_id_64, t0.lighting_contract_id AS lighting_contract_id_65, t0.campaign_lighting_id AS campaign_lighting_id_66, t0.campaign_consent_id AS campaign_consent_id_67, t0.bank_account_id AS bank_account_id_68, t0.payment_transfer_approvel_user_id AS payment_transfer_approvel_user_id_69, t0.hotel_profit_id AS hotel_profit_id_70, t0.currency_rate_id AS currency_rate_id_71, t0.tour_package_contract_id AS tour_package_contract_id_72, t0.site_id AS site_id_73 FROM reservation t0 LEFT JOIN comment t37 ON t37.reservation_id = t0.id LEFT JOIN puzzle_reservation_forwarding t43 ON t43.reservation_id = t0.id WHERE t0.guid = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
"guid_4Xwj2oFha8jUpLZvCLiNFWppe"
]
|
2.02 ms (0.97%) |
1 |
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:
[
82988
]
|
1.87 ms (0.90%) |
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 = ? AND p0_.hotel_destination_id IN (?) AND p0_.site_id = ? LIMIT 1
Parameters:
[ 1 [ 21 8 ] 2 ] |
1.63 ms (0.78%) |
1 |
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:
[
5
]
|
1.61 ms (0.77%) |
1 |
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_.id NOT IN (?) AND h0_.provider <= ? AND h0_.max_price >= ? AND h0_.min_price <= ? AND h0_.currency <= ?
Parameters:
[ [ 1 ] "PZ" 29181.6 29181.6 "TRY" ] |
1.32 ms (0.63%) |
1 |
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:
[ "PACKAGE" 2 ] |
1.15 ms (0.55%) |
1 |
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:
[
82988
]
|
1.15 ms (0.55%) |
1 |
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:
[
82988
]
|
1.09 ms (0.52%) |
1 |
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:
[
37653
]
|
1.02 ms (0.49%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4, t0.iata_code AS iata_code_5 FROM airport t0 WHERE t0.id = ?
Parameters:
[
186
]
|
0.98 ms (0.47%) |
1 |
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:
[
3347
]
|
0.90 ms (0.43%) |
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))
Parameters:
[
82988
]
|
0.89 ms (0.43%) |
1 |
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:
[
82988
]
|
0.89 ms (0.42%) |
1 |
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:
[
101
]
|
0.79 ms (0.38%) |
1 |
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:
[
82988
]
|
0.77 ms (0.37%) |
1 |
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:
[
82988
]
|
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\ReservationFlightSegment | No errors. |
App\Entity\ReservationFlightTicket | 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\AirportTranslation | No errors. |
App\Entity\RefundPax |
|
App\Entity\RefundReservation | No errors. |
App\Entity\PaymentPartial | No errors. |
App\Entity\PaymentPartialSettingTranslation | No errors. |