Query Metrics
18
Database Queries
8
Different statements
80.36 ms
Query time
19
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 2.26 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:
[
"QUxCQVRST1M6MTcyMDE3NTAyNA=="
]
|
2 | 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"
]
|
3 | 0.85 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:
[
78
]
|
4 | 0.86 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.87 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.76 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.73 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 | 0.80 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"
]
|
9 | 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"
]
|
10 | 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"
]
|
11 | 0.82 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"
]
|
12 | 64.16 ms |
SELECT s0_.id AS id_0, s0_.slug AS slug_1, s0_.type AS type_2, s0_.meta_title AS meta_title_3, s0_.meta_description AS meta_description_4, s0_.meta_keyword AS meta_keyword_5, s0_.status AS status_6, s0_.redirect AS redirect_7, s0_.redirect_code AS redirect_code_8, s0_.marketing_campaign_id AS marketing_campaign_id_9, s0_.hotel_destination_id AS hotel_destination_id_10, s0_.hotel_category_id AS hotel_category_id_11, s0_.hotel_id AS hotel_id_12, s0_.tour_destination_id AS tour_destination_id_13, s0_.tour_id AS tour_id_14, s0_.tour_category_id AS tour_category_id_15, s0_.tour_type_id AS tour_type_id_16, s0_.landmark_id AS landmark_id_17, s0_.destination_hotel_id AS destination_hotel_id_18, s0_.tour_hotel_destination_id AS tour_hotel_destination_id_19, s0_.tour_country_id AS tour_country_id_20, s0_.hotel_page_destination_id AS hotel_page_destination_id_21 FROM seo_page s0_ LEFT JOIN seo_page_sites s1_ ON s0_.id = s1_.seo_page_id WHERE s0_.status = 1 AND s1_.slug = ? AND s1_.site_id = ? LIMIT 1
Parameters:
[ "/" 2 ] |
13 | 1.03 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:
[
14830
]
|
14 | 0.97 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"
]
|
15 | 0.68 ms |
SELECT t0.id AS id_1, t0.product AS product_2, t0.type AS type_3, t0.agency_id AS agency_id_4 FROM agency_product t0 WHERE t0.agency_id = ?
Parameters:
[
78
]
|
16 | 0.81 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"
]
|
17 | 1.61 ms |
SELECT d0_.id AS id_0, d0_.code AS code_1, d0_.limit_count AS limit_count_2, d0_.remaining_count AS remaining_count_3, d0_.discount_id AS discount_id_4 FROM discount_coupons d0_ LEFT JOIN discount d1_ ON d0_.discount_id = d1_.id LEFT JOIN discount_agency d3_ ON d1_.id = d3_.discount_id LEFT JOIN agency a2_ ON a2_.id = d3_.agency_id AND (a2_.deleted_at IS NULL) WHERE d1_.status = 1 AND d1_.popup_seo_url_id = ? AND d0_.remaining_count > ? AND (a2_.id IS NULL OR a2_.id NOT IN (?)) AND d1_.site_id = ? LIMIT 1
Parameters:
[ 14830 0 [ 78 ] 2 ] |
18 | 0.95 ms |
SELECT h0_.id AS id_0, h0_.min_acc AS min_acc_1, h0_.reservation_start_date AS reservation_start_date_2, h0_.reservation_end_date AS reservation_end_date_3, h0_.acc_start_date AS acc_start_date_4, h0_.acc_end_date AS acc_end_date_5, h0_.discount_rate AS discount_rate_6, h0_.discount_type AS discount_type_7, h0_.sequence AS sequence_8, h0_.status AS status_9, h0_.description AS description_10, h0_.direction AS direction_11, h0_.cost_affect AS cost_affect_12, h0_.discount_bracket AS discount_bracket_13, h0_.hotel_id AS hotel_id_14, h0_.destination_id AS destination_id_15, h0_.site_id AS site_id_16, h0_.tour_id AS tour_id_17, h0_.tour_category_id AS tour_category_id_18 FROM hotel_minute_deals h0_ WHERE h0_.status = ? AND h0_.reservation_start_date <= ? AND h0_.reservation_end_date >= ? AND h0_.site_id = ? ORDER BY h0_.sequence DESC
Parameters:
[ 1 "2024-09-21 16:54:47" "2024-09-21 16:54:47" 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\HotelCategory |
|
App\Entity\SeoPage |
|
App\Entity\HotelFacality | No errors. |
App\Entity\Airport |
|
App\Entity\HotelProfit | No errors. |
App\Entity\TourPrice | No errors. |
App\Entity\CurrencyRate |
|
App\Entity\HotelEvent | No errors. |
App\Entity\TourTypeLabel |
|
App\Entity\FavoriteHotelUser | No errors. |
App\Entity\AvailableHotelRoomPrice |
|
App\Entity\Transfer | No errors. |
App\Entity\HotelImageType | No errors. |
App\Entity\Review |
|
App\Entity\Comment | No errors. |
App\Entity\PuzzleTransferPrice | No errors. |
App\Entity\TourCategory |
|
App\Entity\DiscountCoupons | No errors. |
App\Entity\TourType | No errors. |
App\Entity\TourCountry | No errors. |
App\Entity\SeoPageArticle | No errors. |
App\Entity\SeoMenu | No errors. |
App\Entity\FAQCategory |
|
App\Entity\HotelHotelRoom | No errors. |
App\Entity\SeoPageTranslation | No errors. |