Query Metrics
10
Database Queries
9
Different statements
9.84 ms
Query time
2
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
3.53 ms (35.90%) |
1 |
"COMMIT"
Parameters:
[] |
1.38 ms (14.03%) |
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"
]
|
1.38 ms (13.99%) |
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:
[
199
]
|
0.84 ms (8.54%) |
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:
[
539
]
|
0.81 ms (8.23%) |
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:
[
"199"
]
|
0.67 ms (6.86%) |
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:
[
"539"
]
|
0.51 ms (5.21%) |
1 |
UPDATE ht_menu SET updated_at = ? WHERE id = ?
Parameters:
[ "2024-11-14 17:20:47" 539 ] |
0.40 ms (4.02%) |
1 |
INSERT INTO ht_menu_escandallo (ht_menu_id, escandallo_id) VALUES (?, ?)
Parameters:
[ 539 199 ] |
0.32 ms (3.22%) |
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. |