Query Metrics
11
Database Queries
8
Different statements
22.18 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.71 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.upload AS upload_4, t0.description AS description_5 FROM environment_parameter t0
Parameters:
[] |
| 2 | 1.06 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.upload AS upload_4, t0.description AS description_5 FROM environment_parameter t0
Parameters:
[] |
| 3 | 1.08 ms |
SELECT e0_.id AS id_0, e0_.header_background_color AS header_background_color_1, e0_.wrapper_background_color AS wrapper_background_color_2, e0_.content_background_color AS content_background_color_3, e0_.text_color AS text_color_4, e0_.link_color AS link_color_5, e0_.heading_color AS heading_color_6, e0_.button_background_color AS button_background_color_7, e0_.button_text_color AS button_text_color_8, e0_.font_family AS font_family_9, e0_.logo_filename AS logo_filename_10, e0_.logo_width AS logo_width_11, e0_.footer_extra_html AS footer_extra_html_12, e0_.social_facebook_url AS social_facebook_url_13, e0_.social_instagram_url AS social_instagram_url_14, e0_.social_linkedin_url AS social_linkedin_url_15, e0_.mail_proposal_text AS mail_proposal_text_16, e0_.mail_order_text AS mail_order_text_17, e0_.mail_invoice_text AS mail_invoice_text_18, e0_.mail_invoice_with_pay_url_text AS mail_invoice_with_pay_url_text_19, e0_.mail_invoice_reminder_text AS mail_invoice_reminder_text_20, e0_.mail_invoice_reminder_with_pay_url_text AS mail_invoice_reminder_with_pay_url_text_21, e0_.mail_invoice_text_direct_debit AS mail_invoice_text_direct_debit_22, e0_.mail_proposal_subject AS mail_proposal_subject_23, e0_.mail_order_subject AS mail_order_subject_24, e0_.mail_invoice_subject AS mail_invoice_subject_25, e0_.mail_invoice_with_pay_url_subject AS mail_invoice_with_pay_url_subject_26, e0_.mail_invoice_reminder_subject AS mail_invoice_reminder_subject_27, e0_.mail_invoice_reminder_with_pay_url_subject AS mail_invoice_reminder_with_pay_url_subject_28, e0_.mail_invoice_subject_direct_debit AS mail_invoice_subject_direct_debit_29, e0_.default_mail_pdf_with_template AS default_mail_pdf_with_template_30, e0_.modify_date AS modify_date_31, e0_.modified_by_user_id AS modified_by_user_id_32 FROM email_branding e0_ ORDER BY e0_.id ASC LIMIT 1
Parameters:
[] |
| 4 | 1.00 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.upload AS upload_4, t0.description AS description_5 FROM environment_parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"voip_number"
]
|
| 5 | 1.10 ms |
SELECT t0.id AS id_1, t0.voip_identification AS voip_identification_2, t0.remark AS remark_3, t0.phone_number AS phone_number_4, t0.destination_number AS destination_number_5, t0.start_call_date AS start_call_date_6, t0.end_call_date AS end_call_date_7, t0.is_incoming AS is_incoming_8, t0.is_answered AS is_answered_9, t0.is_processed AS is_processed_10, t0.create_date AS create_date_11, t0.modify_date AS modify_date_12, t0.is_deleted AS is_deleted_13, t0.call_duration AS call_duration_14, t0.customer_id AS customer_id_15, t0.matched_delivery_address_id AS matched_delivery_address_id_16, t0.dossier_id AS dossier_id_17, t0.created_by_user_id AS created_by_user_id_18, t0.modified_by_user_id AS modified_by_user_id_19, t0.call_category_id AS call_category_id_20, t0.related_order_id AS related_order_id_21, t0.related_proposal_id AS related_proposal_id_22, t0.related_ticket_id AS related_ticket_id_23, t0.related_appointment_id AS related_appointment_id_24, t0.related_complaint_id AS related_complaint_id_25, t0.related_sales_lead_id AS related_sales_lead_id_26, t0.related_task_id AS related_task_id_27 FROM call_history t0 WHERE t0.voip_identification = ? LIMIT 1
Parameters:
[
"1781204065.63616"
]
|
| 6 | 0.40 ms |
"START TRANSACTION"
Parameters:
[] |
| 7 | 1.06 ms |
INSERT INTO event_log (category, title, description, date, user_id) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "Info" "Inbound VOIP Call End" "uuid=1781204065.63616&direction=inbound&source=31624114111&destination=&recordingfile=&duration=0&disposition=MISSED&calldate=1781204079×tamp=1781204065&contexts%5B0%5D=from-pstn-toheader-e164-nl&contexts%5B1%5D=app-announcement-1&contexts%5B2%5D=ext-queues&contexts%5B3%5D=from-queue&contexts%5B4%5D=ext-local&contexts%5B5%5D=from-internal&clid=%220624114111%22+%3C0624114111%3E&cnum=0624114111&callend=1&type=END&voicemail=&destNumber=&owner=0" "2026-06-11 20:54:44" null ] |
| 8 | 8.08 ms |
"COMMIT"
Parameters:
[] |
| 9 | 0.54 ms |
"START TRANSACTION"
Parameters:
[] |
| 10 | 1.03 ms |
UPDATE call_history SET end_call_date = ?, modify_date = ? WHERE id = ?
Parameters:
[ "2026-06-11 20:54:39" "2026-06-11 20:54:44" 47451 ] |
| 11 | 5.12 ms |
"COMMIT"
Parameters:
[] |
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\EnvironmentParameter | No errors. |
| App\Entity\EmailBranding | No errors. |
| App\Entity\User | No errors. |
| App\Entity\CallHistory | No errors. |
| App\Entity\Customer | No errors. |
| App\Entity\CustomerDeliveryAddress | No errors. |
| App\Entity\Dossier | No errors. |
| App\Entity\CallCategory | No errors. |
| App\Entity\Order | No errors. |
| App\Entity\Proposal | No errors. |
| App\Entity\Ticket | No errors. |
| App\Entity\Appointment | No errors. |
| App\Entity\Complaint | No errors. |
| App\Entity\SalesLead | No errors. |
| App\Entity\Task | No errors. |
| App\Entity\EventLog | No errors. |