Query Metrics
5
Database Queries
4
Different statements
7.11 ms
Query time
10
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
3.06 ms (43.01%) |
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:
[
"R1JVUCBBTktBOjE3MjA1OTg2MTc="
]
|
2.09 ms (29.45%) |
2 |
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"
]
|
1.03 ms (14.46%) |
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:
[
83
]
|
0.93 ms (13.09%) |
1 |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.status AS status_3, t0.reservation_id AS reservation_id_4, t0.agency_id AS agency_id_5 FROM notification_agency t0 WHERE t0.agency_id = ? ORDER BY t0.status DESC, t0.id DESC
Parameters:
[
83
]
|
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\NotificationAgency | No errors. |