Query Metrics
11
Database Queries
3
Different statements
12.20 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
5.35 ms (43.83%) |
1 |
SELECT h0_.id AS id_0, h0_.title AS title_1, h0_.status AS status_2, h0_.days_block AS days_block_3, h0_.pax AS pax_4, h0_.description AS description_5, h0_.description_two AS description_two_6, h0_.contact_unregistered AS contact_unregistered_7, h0_.name_contact_unregistered AS name_contact_unregistered_8, h0_.phone_contact_unregistered AS phone_contact_unregistered_9, h0_.date_start AS date_start_10, h0_.date_end AS date_end_11, h0_.created_at AS created_at_12, h0_.updated_at AS updated_at_13, h0_.client_type AS client_type_14, h0_.client_id AS client_id_15, h0_.proposal_id AS proposal_id_16, h0_.created_id_id AS created_id_id_17, h0_.updated_id_id AS updated_id_id_18, h0_.client_contact_id AS client_contact_id_19, h0_.reservation_id AS reservation_id_20 FROM ht_file h0_ WHERE h0_.date_start >= ? AND h0_.date_end >= h0_.date_start AND h0_.reservation_id IS NULL ORDER BY h0_.date_start ASC
Parameters:
[
"2024-01-01 00:00:00"
]
|
|
4.87 ms (39.93%) |
8 |
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.id = ?
Parameters:
[
116
]
|
|
1.98 ms (16.24%) |
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:
[
"giulia.roger@inout-travel.com"
]
|
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\HtFile | No errors. |
| App\Entity\Client | No errors. |
| App\MDS\EventsBundle\Entity\Proposal | No errors. |
| App\Entity\ClientContact | No errors. |
| App\MDS\GreenPatioBundle\Entity\Reservation | No errors. |
| App\Entity\HtItem |
|
| App\Entity\HtVisit | No errors. |