Query Metrics
10
Database Queries
9
Different statements
8.76 ms
Query time
2
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
3.46 ms (39.52%) |
1 |
"COMMIT"
Parameters:
[] |
1.38 ms (15.76%) |
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:
[
"gonzalo.alonso@higotrigo.com"
]
|
0.79 ms (9.06%) |
1 |
SELECT t0.id AS id_1, t0.beneficio AS beneficio_2, t0.total_price AS total_price_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.template AS template_6, t0.name AS name_7, t0.iva AS iva_8, t0.created_id_id AS created_id_id_9, t0.updated_id_id AS updated_id_id_10, t0.ht_item_id AS ht_item_id_11 FROM ht_menu t0 INNER JOIN ht_menu_escandallo ON t0.id = ht_menu_escandallo.ht_menu_id WHERE ht_menu_escandallo.escandallo_id = ?
Parameters:
[
144
]
|
0.78 ms (8.86%) |
1 |
SELECT t0.id AS id_1, t0.total_ten_pax AS total_ten_pax_2, t0.coste_pax AS coste_pax_3, t0.pvp AS pvp_4, t0.pvp_not_vat AS pvp_not_vat_5, t0.coste_directo_perc AS coste_directo_perc_6, t0.beneficio AS beneficio_7, t0.foto AS foto_8, t0.decription AS decription_9, t0.observaciones AS observaciones_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.nombre AS nombre_13, t0.escandallo_pax AS escandallo_pax_14, t0.created_id_id AS created_id_id_15, t0.updated_id_id AS updated_id_id_16, t0.family_escandallo_id AS family_escandallo_id_17 FROM escandallo t0 WHERE t0.id = ?
Parameters:
[
"144"
]
|
0.75 ms (8.50%) |
1 |
SELECT t0.id AS id_1, t0.beneficio AS beneficio_2, t0.total_price AS total_price_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.template AS template_6, t0.name AS name_7, t0.iva AS iva_8, t0.created_id_id AS created_id_id_9, t0.updated_id_id AS updated_id_id_10, t0.ht_item_id AS ht_item_id_11 FROM ht_menu t0 WHERE t0.id = ?
Parameters:
[
"542"
]
|
0.65 ms (7.41%) |
1 |
SELECT t0.id AS id_1, t0.total_ten_pax AS total_ten_pax_2, t0.coste_pax AS coste_pax_3, t0.pvp AS pvp_4, t0.pvp_not_vat AS pvp_not_vat_5, t0.coste_directo_perc AS coste_directo_perc_6, t0.beneficio AS beneficio_7, t0.foto AS foto_8, t0.decription AS decription_9, t0.observaciones AS observaciones_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.nombre AS nombre_13, t0.escandallo_pax AS escandallo_pax_14, t0.created_id_id AS created_id_id_15, t0.updated_id_id AS updated_id_id_16, t0.family_escandallo_id AS family_escandallo_id_17 FROM escandallo t0 INNER JOIN ht_menu_escandallo ON t0.id = ht_menu_escandallo.escandallo_id WHERE ht_menu_escandallo.ht_menu_id = ?
Parameters:
[
542
]
|
0.38 ms (4.37%) |
1 |
UPDATE ht_menu SET updated_at = ? WHERE id = ?
Parameters:
[ "2024-11-14 17:25:47" 542 ] |
0.34 ms (3.91%) |
1 |
INSERT INTO ht_menu_escandallo (ht_menu_id, escandallo_id) VALUES (?, ?)
Parameters:
[ 542 144 ] |
0.23 ms (2.60%) |
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\Escandallo | No errors. |
App\Entity\FamilyEscandallo | No errors. |
App\Entity\EscandalloProduct | No errors. |
App\Entity\HtMenu |
|
App\Entity\HtNote | No errors. |
App\Entity\HtItem |
|
App\Entity\HtExtra | No errors. |