Query Metrics
10
Database Queries
7
Different statements
36.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
17.40 ms (48.20%) |
1 |
SELECT c.id AS customerId FROM `customer` c WHERE c.is_deleted = false AND (REPLACE(REPLACE(REPLACE(c.phone_primary, '-', ''), '+', ''), ' ', '') LIKE ? OR REPLACE(REPLACE(REPLACE(c.phone_secondary, '-', ''), '+', ''), ' ', '') LIKE ?) ORDER BY create_date DESC LIMIT 1;
Parameters:
[ "%548512454%" "%548512454%" ] |
|
12.64 ms (35.03%) |
2 |
"COMMIT"
Parameters:
[] |
|
2.45 ms (6.78%) |
2 |
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:
[] |
|
0.93 ms (2.58%) |
1 |
INSERT INTO event_log (category, title, description, date, user_id) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "Info" "Outbound VOIP Call Start" "uuid=1771428359.239852&direction=outbound&disposition=UNKNOWN&source=505&destination=0031548512454&recordingfile=&duration=0&calldate=1771428359×tamp=1771428359&clid=&cnam=&cnum=&type=START&voicemail=&owner=0" "2026-02-18 16:26:00" null ] |
|
0.90 ms (2.49%) |
2 |
"START TRANSACTION"
Parameters:
[] |
|
0.89 ms (2.46%) |
1 |
INSERT INTO call_history (voip_identification, remark, phone_number, destination_number, start_call_date, end_call_date, is_incoming, is_answered, is_processed, create_date, modify_date, is_deleted, call_duration, customer_id, matched_delivery_address_id, dossier_id, created_by_user_id, modified_by_user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "1771428359.239852" null "Kassa PC links (505)" "0548512454" "2026-02-18 16:25:59" null 0 0 0 "2026-02-18 16:26:00" null 0 null 4127 null null null null ] |
|
0.88 ms (2.45%) |
1 |
SELECT t0.id AS id_1, t0.snelstart_identification AS snelstart_identification_2, t0.customer_number AS customer_number_3, t0.is_business AS is_business_4, t0.company_name AS company_name_5, t0.kvk_number AS kvk_number_6, t0.btw_number AS btw_number_7, t0.first_name AS first_name_8, t0.last_name AS last_name_9, t0.invoice_address AS invoice_address_10, t0.invoice_postal_code AS invoice_postal_code_11, t0.invoice_city AS invoice_city_12, t0.invoice_latitude AS invoice_latitude_13, t0.invoice_longitude AS invoice_longitude_14, t0.delivery_address AS delivery_address_15, t0.delivery_postal_code AS delivery_postal_code_16, t0.delivery_city AS delivery_city_17, t0.delivery_latitude AS delivery_latitude_18, t0.delivery_longitude AS delivery_longitude_19, t0.email AS email_20, t0.financial_email AS financial_email_21, t0.backoffice_email AS backoffice_email_22, t0.phone_primary AS phone_primary_23, t0.phone_primary_remark AS phone_primary_remark_24, t0.phone_secondary AS phone_secondary_25, t0.phone_secondary_remark AS phone_secondary_remark_26, t0.remark AS remark_27, t0.term_of_payment AS term_of_payment_28, t0.create_date AS create_date_29, t0.modify_date AS modify_date_30, t0.is_deleted AS is_deleted_31, t0.invoice_address_equals_delivery AS invoice_address_equals_delivery_32, t0.snelstart_direct_debit_contract_identification AS snelstart_direct_debit_contract_identification_33, t0.iban AS iban_34, t0.invoice_country_id AS invoice_country_id_35, t0.delivery_country_id AS delivery_country_id_36, t0.created_by_user_id AS created_by_user_id_37, t0.modified_by_user_id AS modified_by_user_id_38, t0.responsible_user_id AS responsible_user_id_39 FROM customer t0 WHERE t0.id = ?
Parameters:
[
4127
]
|
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\EventLog | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Customer | No errors. |
| App\Entity\Country | No errors. |
| App\Entity\Dossier | No errors. |
| App\Entity\FinancialCustomer | No errors. |
| App\Entity\CallHistory | No errors. |
| App\Entity\SnelstartApiLog | No errors. |
| App\Entity\Ticket | No errors. |
| App\Entity\SalesLead | No errors. |
| App\Entity\OrderTemplate | No errors. |
| App\Entity\Appointment | No errors. |
| App\Entity\Task | No errors. |
| App\Entity\CustomerDeliveryAddress | No errors. |
| App\Entity\Complaint | No errors. |
| App\Entity\CustomerNote | No errors. |