Query Metrics
6
Database Queries
6
Different statements
3.23 ms
Query time
4
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.18 ms (36.47%) |
1 |
SELECT t0.created_at AS created_at_1, t0.phone AS phone_2, t0.first_name AS first_name_3, t0.sure_name AS sure_name_4, t0.father_name AS father_name_5, t0.farpost_login AS farpost_login_6, t0.email AS email_7, t0.mango_contact_id AS mango_contact_id_8, t0.id AS id_9, t0.user_id AS user_id_10 FROM customers__customers t0 WHERE t0.phone = ? LIMIT 1
Parameters:
[
"9997419252"
]
|
0.68 ms (20.99%) |
1 |
SELECT t0.created_at AS created_at_1, t0.phone AS phone_2, t0.sip_id AS sip_id_3, t0.recording_id AS recording_id_4, t0.status AS status_5, t0.duration AS duration_6, t0.direction AS direction_7, t0.missed_status AS missed_status_8, t0.id AS id_9, t0.updated AS updated_10, t0.manager_id AS manager_id_11, t0.customer_id AS customer_id_12, t13.created_at AS created_at_14, t13.canceled_at AS canceled_at_15, t13.transmission_time AS transmission_time_16, t13.phone AS phone_17, t13.car_brand AS car_brand_18, t13.car_model AS car_model_19, t13.car_vin AS car_vin_20, t13.town_name AS town_name_21, t13.comment AS comment_22, t13.confirmed AS confirmed_23, t13.deprecated_order_id AS deprecated_order_id_24, t13.id AS id_25, t13.customer_id AS customer_id_26, t13.user_id AS user_id_27, t13.mango_call_id AS mango_call_id_28, t13.order_id AS order_id_29 FROM mango__calls t0 LEFT JOIN leads__leads t13 ON t13.mango_call_id = t0.id WHERE t0.sip_id = ? LIMIT 1
Parameters:
[
"MjI2OTE4MjIyOTM="
]
|
0.58 ms (17.95%) |
1 |
SELECT t0.created_at AS created_at_1, t0.phone AS phone_2, t0.sip_id AS sip_id_3, t0.recording_id AS recording_id_4, t0.status AS status_5, t0.duration AS duration_6, t0.direction AS direction_7, t0.missed_status AS missed_status_8, t0.id AS id_9, t0.updated AS updated_10, t0.manager_id AS manager_id_11, t0.customer_id AS customer_id_12, t13.created_at AS created_at_14, t13.canceled_at AS canceled_at_15, t13.transmission_time AS transmission_time_16, t13.phone AS phone_17, t13.car_brand AS car_brand_18, t13.car_model AS car_model_19, t13.car_vin AS car_vin_20, t13.town_name AS town_name_21, t13.comment AS comment_22, t13.confirmed AS confirmed_23, t13.deprecated_order_id AS deprecated_order_id_24, t13.id AS id_25, t13.customer_id AS customer_id_26, t13.user_id AS user_id_27, t13.mango_call_id AS mango_call_id_28, t13.order_id AS order_id_29 FROM mango__calls t0 LEFT JOIN leads__leads t13 ON t13.mango_call_id = t0.id WHERE t0.phone = ? AND t0.missed_status = ?
Parameters:
[ "9997419252" "missed" ] |
0.45 ms (13.83%) |
1 |
UPDATE mango__calls SET status = ?, duration = ?, updated = ? WHERE id = ?
Parameters:
[ "ANSWERED" 18 "2025-01-23 13:19:29" 22897 ] |
0.18 ms (5.71%) |
1 |
"COMMIT"
Parameters:
[] |
0.16 ms (5.06%) |
1 |
"START TRANSACTION"
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\BrandAlias | No errors. |
App\Entity\ProductImage | No errors. |
App\Entity\Customer |
|
App\Entity\User |
|
App\Entity\MangoCall |
|
App\Entity\Manager | No errors. |
App\Entity\Lead | No errors. |
App\Entity\Order |
|