Query Metrics
3
Database Queries
2
Different statements
1.26 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.57 ms |
SELECT t0.id AS id_1, t0.access_token AS access_token_2, t0.refresh_token AS refresh_token_3, t0.access_token_expiry AS access_token_expiry_4 FROM secret t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
| 2 | 0.17 ms |
SELECT t0.id AS id_1, t0.access_token AS access_token_2, t0.refresh_token AS refresh_token_3, t0.access_token_expiry AS access_token_expiry_4 FROM secret t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
| 3 | 0.52 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.date_add AS date_add_3, t0.date_modify AS date_modify_4, t0.content AS content_5, t0.coordinator AS coordinator_6, t0.coordinator_phone AS coordinator_phone_7, t0.coordinator2 AS coordinator2_8, t0.coordinator_phone2 AS coordinator_phone2_9, t0.email_poster AS email_poster_10, t0.date_of_visit AS date_of_visit_11, t0.date_of_contact AS date_of_contact_12, t0.kond_of_dome AS kond_of_dome_13, t0.number_of_children AS number_of_children_14, t0.rate AS rate_15, t0.provision AS provision_16, t0.payment_method AS payment_method_17, t0.billing_type AS billing_type_18, t0.number_of_kilometers AS number_of_kilometers_19, t0.fuel_price AS fuel_price_20, t0.event_id AS event_id_21, t0.user_event_id AS user_event_id_22, t0.number_of_group AS number_of_group_23, t0.time_of_visit AS time_of_visit_24, t0.description AS description_25, t0.other_costs AS other_costs_26, t0.costs_accommodation AS costs_accommodation_27, t0.invoices_fuel AS invoices_fuel_28, t0.downloaded_in_cash AS downloaded_in_cash_29, t0.add_other_ticket AS add_other_ticket_30, t0.flexibility AS flexibility_31, t0.first_contact AS first_contact_32, t0.status_id AS status_id_33, t0.institutions_id AS institutions_id_34, t0.user_id AS user_id_35, t0.advertisement_poster_id AS advertisement_poster_id_36, t37.id AS id_38, t37.deposit AS deposit_39, t37.date AS date_40, t37.is_public AS is_public_41, t37.date_add AS date_add_42, t37.old_ticket_number AS old_ticket_number_43, t37.note AS note_44, t37.user_id AS user_id_45, t37.ticket_id AS ticket_id_46, t47.id AS id_48, t47.first_name AS first_name_49, t47.last_name AS last_name_50, t47.phone AS phone_51, t47.email AS email_52, t47.rate AS rate_53, t47.provision AS provision_54, t47.sms AS sms_55, t47.offer AS offer_56, t47.date_reservation AS date_reservation_57, t47.date_add AS date_add_58, t47.date_modify AS date_modify_59, t47.next_contact_date AS next_contact_date_60, t47.next_contact_time AS next_contact_time_61, t47.status_id AS status_id_62, t47.institutions_id AS institutions_id_63, t47.owner_id AS owner_id_64, t47.ticket_id AS ticket_id_65 FROM tickets t0 LEFT JOIN cash_deposits t37 ON t37.ticket_id = t0.id LEFT JOIN leads t47 ON t47.ticket_id = t0.id WHERE t0.id = ?
Parameters:
[
"5923"
]
|
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\Secret | No errors. |
| App\Entity\Other\Tickets\Tickets | No errors. |
| App\Entity\Other\Tickets\TicketsStatus | No errors. |
| App\Entity\Other\Institutions\Institutions | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Other\AdvertisementPoster\AdvertisementPoster | No errors. |
| App\Entity\Other\Tickets\CashDeposits | No errors. |
| App\Entity\Other\Leads\Leads | No errors. |
| App\Entity\Other\Leads\LeadsStatus | No errors. |
| App\Entity\Core\Comments | No errors. |
| App\Entity\Other\Tickets\TicketsHistory | No errors. |
| App\Entity\Core\Files\Files | No errors. |
| App\Entity\Other\Invoices\Invoices | No errors. |