Query Metrics
4
Database Queries
4
Different statements
2.09 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.95 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:
[
"3440"
]
|
| 2 | 0.61 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.confirmed AS confirmed_6, t0.actived AS actived_7, t0.access AS access_8, t0.date_register AS date_register_9, t0.date_activity AS date_activity_10, t0.api_token AS api_token_11, t0.google_calendar AS google_calendar_12, t0.google_order AS google_order_13, t14.id AS id_15, t14.name AS name_16, t14.last_name AS last_name_17, t14.phone AS phone_18, t14.street AS street_19, t14.postcode AS postcode_20, t14.city AS city_21, t14.nip AS nip_22, t14.company AS company_23, t14.regon AS regon_24, t14.home_number AS home_number_25, t14.apartment_number AS apartment_number_26, t14.description AS description_27, t14.social_facebook AS social_facebook_28, t14.social_twitter AS social_twitter_29, t14.social_instagram AS social_instagram_30, t14.social_linkedin AS social_linkedin_31, t14.social_youtube AS social_youtube_32, t14.color AS color_33, t14.paycheck_procent AS paycheck_procent_34, t14.second_color AS second_color_35, t14.user_id AS user_id_36, t14.photo_id AS photo_id_37, t14.user_email_template_id AS user_email_template_id_38, t39.id AS id_40, t39.sender_email AS sender_email_41, t39.sender_label AS sender_label_42, t39.sender_pass AS sender_pass_43, t39.sender_host AS sender_host_44, t39.sender_port AS sender_port_45, t39.footer AS footer_46, t39.receiver_host AS receiver_host_47, t39.receiver_port AS receiver_port_48, t39.last_generation_imap_ai_response AS last_generation_imap_ai_response_49, t39.user_id AS user_id_50, t51.id AS id_52, t51.title AS title_53, t51.car_type AS car_type_54, t51.date_add AS date_add_55, t51.date_modify AS date_modify_56, t51.content AS content_57, t51.combustion AS combustion_58, t51.current_odometer AS current_odometer_59, t51.odometer_since_inspection AS odometer_since_inspection_60, t51.insurance_expiration_date AS insurance_expiration_date_61, t51.inspection_expiration_date AS inspection_expiration_date_62, t51.status_id AS status_id_63, t51.user_id AS user_id_64, t65.id AS id_66, t65.title AS title_67, t65.date_add AS date_add_68, t65.date_modify AS date_modify_69, t65.number AS number_70, t65.register_date AS register_date_71, t65.service_date AS service_date_72, t65.status_id AS status_id_73, t65.user_id AS user_id_74 FROM `user` t0 LEFT JOIN user_data t14 ON t14.user_id = t0.id LEFT JOIN user_email t39 ON t39.user_id = t0.id LEFT JOIN cars t51 ON t51.user_id = t0.id LEFT JOIN cash_registers t65 ON t65.user_id = t0.id WHERE t0.id = ?
Parameters:
[
16
]
|
| 3 | 0.25 ms |
SELECT t0.id AS id_1, t0.posted_date AS posted_date_2, t0.comment AS comment_3, t0.is_public AS is_public_4, t0.parent_id AS parent_id_5, t0.author_id AS author_id_6, t0.tasks_id AS tasks_id_7, t0.tickets_id AS tickets_id_8, t0.files_id AS files_id_9, t0.institutions_id AS institutions_id_10, t0.invoices_id AS invoices_id_11, t0.cars_id AS cars_id_12, t0.advertisement_poster_id AS advertisement_poster_id_13, t0.campaigns_id AS campaigns_id_14, t0.contacts_list_id AS contacts_list_id_15, t0.leads_id AS leads_id_16, t0.cash_registers_id AS cash_registers_id_17 FROM comments t0 WHERE t0.id IS NULL AND t0.is_public = ? AND t0.tickets_id = ? LIMIT 1
Parameters:
[ 1 3440 ] |
| 4 | 0.27 ms |
SELECT t0.id AS id_1, t0.posted_date AS posted_date_2, t0.comment AS comment_3, t0.is_public AS is_public_4, t0.parent_id AS parent_id_5, t0.author_id AS author_id_6, t0.tasks_id AS tasks_id_7, t0.tickets_id AS tickets_id_8, t0.files_id AS files_id_9, t0.institutions_id AS institutions_id_10, t0.invoices_id AS invoices_id_11, t0.cars_id AS cars_id_12, t0.advertisement_poster_id AS advertisement_poster_id_13, t0.campaigns_id AS campaigns_id_14, t0.contacts_list_id AS contacts_list_id_15, t0.leads_id AS leads_id_16, t0.cash_registers_id AS cash_registers_id_17 FROM comments t0 WHERE t0.parent_id IS NULL AND t0.is_public = ? AND t0.tickets_id = ? ORDER BY t0.id DESC
Parameters:
[ 1 3440 ] |
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.