Query Metrics
27
Database Queries
8
Different statements
27.62 ms
Query time
19
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
10.78 ms (39.04%) |
12 |
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.68 ms (20.55%) |
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:
[
"48ad20ecb44a117d53768ed2bb942af01"
]
|
2.60 ms (9.43%) |
3 |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.type AS type_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keyword AS meta_keyword_6, t0.status AS status_7, t0.redirect AS redirect_8, t0.redirect_code AS redirect_code_9, t0.marketing_campaign_id AS marketing_campaign_id_10, t0.hotel_destination_id AS hotel_destination_id_11, t0.hotel_category_id AS hotel_category_id_12, t0.hotel_id AS hotel_id_13, t0.tour_destination_id AS tour_destination_id_14, t0.tour_id AS tour_id_15, t0.tour_category_id AS tour_category_id_16, t0.tour_type_id AS tour_type_id_17, t0.landmark_id AS landmark_id_18, t0.destination_hotel_id AS destination_hotel_id_19, t20.id AS id_21, t20.tour_type_id AS tour_type_id_22, t20.seo_page_id AS seo_page_id_23, t0.tour_hotel_destination_id AS tour_hotel_destination_id_24, t0.tour_country_id AS tour_country_id_25, t0.hotel_page_destination_id AS hotel_page_destination_id_26 FROM seo_page t0 LEFT JOIN tour_type_label t20 ON t20.seo_page_id = t0.id WHERE t0.id = ?
Parameters:
[
14318
]
|
2.34 ms (8.46%) |
3 |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.redirect AS redirect_3, t0.seo_page_id AS seo_page_id_4, t0.site_id AS site_id_5 FROM seo_page_sites t0 WHERE t0.seo_page_id = ?
Parameters:
[
14318
]
|
2.19 ms (7.93%) |
3 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.seo_menu_category_id AS seo_menu_category_id_4 FROM seo_menu_category_translation t0 WHERE t0.seo_menu_category_id = ?
Parameters:
[
48
]
|
2.18 ms (7.89%) |
3 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.sequence AS sequence_3, t0.icon AS icon_4, t0.parent_id AS parent_id_5, t0.seo_page_id AS seo_page_id_6, t0.site_id AS site_id_7 FROM seo_menu_category t0 WHERE t0.parent_id = ?
Parameters:
[
48
]
|
1.02 ms (3.68%) |
1 |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.sequence AS sequence_2, s0_.icon AS icon_3, s0_.parent_id AS parent_id_4, s0_.seo_page_id AS seo_page_id_5, s0_.site_id AS site_id_6 FROM seo_menu_category s0_ INNER JOIN sites s1_ ON s0_.site_id = s1_.id WHERE s1_.name = ? AND s0_.parent_id IS NULL ORDER BY s0_.sequence ASC
Parameters:
[
"PUZZLEBOOKING"
]
|
0.83 ms (3.02%) |
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:
[
4
]
|
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\SeoMenu | No errors. |
App\Entity\SeoMenuCategoryTranslation | No errors. |
App\Entity\TourType | No errors. |
App\Entity\TourCountry | No errors. |
App\Entity\SeoPageArticle | No errors. |
App\Entity\FAQCategory |
|
App\Entity\SeoPageTranslation | No errors. |
App\Entity\SeoPageSitesTranslation | No errors. |