Query Metrics
7
Database Queries
6
Different statements
31.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
22.60 ms (72.15%) |
1 |
SELECT t0.id AS id_1, t0.client_id AS client_id_2, t0.position AS position_3, t0.department AS department_4, t0.type_client AS type_client_5, t0.name AS name_6, t0.last_name AS last_name_7, t0.email AS email_8, t0.password AS password_9, t0.token AS token_10, t0.phone AS phone_11, t0.mobile AS mobile_12, t0.birthday AS birthday_13, t0.assigned_agent AS assigned_agent_14, t0.situation AS situation_15, t0.status AS status_16, t0.created_id AS created_id_17, t0.created_at AS created_at_18, t0.updated_id AS updated_id_19, t0.updated_at AS updated_at_20, t0.picture AS picture_21, t0.newsletter AS newsletter_22 FROM clients_contact t0 WHERE t0.phone = ? LIMIT 1
Parameters:
[
"937 78 71 59"
]
|
|
2.82 ms (9.00%) |
1 |
SELECT u0_.id AS id_0, u0_.picture AS picture_1, u0_.username AS username_2, u0_.email AS email_3, u0_.password AS password_4, u0_.movil_password AS movil_password_5, u0_.pass_gmail AS pass_gmail_6, u0_.firm_gmail AS firm_gmail_7, u0_.name AS name_8, u0_.last_name AS last_name_9, u0_.telephone AS telephone_10, u0_.mobile AS mobile_11, u0_.id_office AS id_office_12, u0_.status AS status_13, u0_.id_company AS id_company_14, u0_.id_user_rol AS id_user_rol_15, u0_.id_team AS id_team_16, u0_.team_leader AS team_leader_17, u0_.role AS role_18, u0_.access_key AS access_key_19, u0_.language AS language_20, u0_.color AS color_21, u0_.vacations AS vacations_22, u0_.half_days AS half_days_23, u0_.sidebar AS sidebar_24, u0_.created_at AS created_at_25, u0_.updated_at AS updated_at_26, u0_.description AS description_27, u0_.job_title AS job_title_28 FROM users u0_ WHERE u0_.status IN (?) ORDER BY u0_.name ASC
Parameters:
[
1
]
|
|
2.76 ms (8.83%) |
1 |
"COMMIT"
Parameters:
[] |
|
1.73 ms (5.52%) |
2 |
SELECT t0.id AS id_1, t0.picture AS picture_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.movil_password AS movil_password_6, t0.pass_gmail AS pass_gmail_7, t0.firm_gmail AS firm_gmail_8, t0.name AS name_9, t0.last_name AS last_name_10, t0.telephone AS telephone_11, t0.mobile AS mobile_12, t0.id_office AS id_office_13, t0.status AS status_14, t0.id_company AS id_company_15, t0.id_user_rol AS id_user_rol_16, t0.id_team AS id_team_17, t0.team_leader AS team_leader_18, t0.role AS role_19, t0.access_key AS access_key_20, t0.language AS language_21, t0.color AS color_22, t0.vacations AS vacations_23, t0.half_days AS half_days_24, t0.sidebar AS sidebar_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.description AS description_28, t0.job_title AS job_title_29 FROM users t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"ricard.valls@inout-travel.com"
]
|
|
1.16 ms (3.71%) |
1 |
INSERT INTO clients_contact (client_id, position, department, type_client, name, last_name, email, password, token, phone, mobile, birthday, assigned_agent, situation, status, created_id, created_at, updated_id, updated_at, picture, newsletter) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "6358" "DIR MKT & COMMUNICATIONS" "MKT" "BT & MICE" "CHIARA" "MARINANZA" "c.marinanza@lasenor.com" null null "937 78 71 59" "937 78 71 59" null 153 "SCOPE" "FIRST CONTACT" 153 "2026-09-10 15:19:02" 153 "2026-09-10 15:19:02" null null ] |
|
0.25 ms (0.79%) |
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\User | No errors. |
| App\Entity\NewsLetterControl | No errors. |
| App\Entity\ClientContact | No errors. |