GET https://crm.planetariumorbitek.pl/tickets/getComments/3440

Query Metrics

4 Database Queries
4 Different statements
2.09 ms Query time
0 Invalid entities

Queries

Group similar statements

# 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.

Entities Mapping

Class Mapping 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.
App\Entity\Other\Leads\LeadsHistory No errors.
App\Entity\Other\TelephoneConnection\TelephoneConnection No errors.
App\Entity\Other\Email\Email No errors.
App\Entity\Core\UserData No errors.
App\Entity\Core\EmailTemplate\EmailTemplate No errors.
App\Entity\Core\UserEmail No errors.
App\Entity\Other\Cars\Cars No errors.
App\Entity\Other\Cars\CarsStatus No errors.
App\Entity\Other\CashRegisters\CashRegisters No errors.
App\Entity\Other\CashRegisters\CashRegistersStatus No errors.
App\Entity\Core\EmailQueue No errors.
App\Entity\Core\Tasks\TasksHistory No errors.
App\Entity\Other\Institutions\InstitutionsHistory No errors.
App\Entity\Core\Messenger\Messenger No errors.
App\Entity\Other\Cars\CarsHistory No errors.
App\Entity\Other\AdvertisementPoster\AdvertisementPosterHistory No errors.
App\Entity\Other\Invoices\InvoicesHistory No errors.
App\Entity\Other\Campaigns\CampaignsHistory No errors.
App\Entity\Other\ContactsList\ContactsListHistory No errors.
App\Entity\Other\Vacations\Vacations No errors.
App\Entity\Core\Tasks\Tasks No errors.
App\Entity\Other\Campaigns\Campaigns No errors.
App\Entity\Other\ContactsList\ContactsList No errors.