Query Metrics
24
Database Queries
5
Different statements
8.79 ms
Query time
2
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.30 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.status AS status_3, t0.days_block AS days_block_4, t0.pax AS pax_5, t0.description AS description_6, t0.description_two AS description_two_7, t0.contact_unregistered AS contact_unregistered_8, t0.name_contact_unregistered AS name_contact_unregistered_9, t0.phone_contact_unregistered AS phone_contact_unregistered_10, t0.date_start AS date_start_11, t0.date_end AS date_end_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.client_type AS client_type_15, t0.client_id AS client_id_16, t0.proposal_id AS proposal_id_17, t0.created_id_id AS created_id_id_18, t0.updated_id_id AS updated_id_id_19, t0.client_contact_id AS client_contact_id_20, t0.reservation_id AS reservation_id_21 FROM ht_file t0 WHERE t0.id = ?
Parameters:
[
"2231"
]
|
2 | 0.74 ms |
SELECT t0.id AS id_1, t0.lounge_other AS lounge_other_2, t0.date_start AS date_start_3, t0.hour_end AS hour_end_4, t0.gratitudes AS gratitudes_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.pax AS pax_8, t0.observation AS observation_9, t0.type AS type_10, t0.reservation_service_id AS reservation_service_id_11, t0.lounge_gp_id AS lounge_gp_id_12, t0.created_id_id AS created_id_id_13, t0.updated_id_id AS updated_id_id_14, t0.ht_file_id AS ht_file_id_15 FROM ht_item t0 WHERE t0.ht_file_id = ?
Parameters:
[
2231
]
|
3 | 0.62 ms |
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.ht_item_id = ?
Parameters:
[
1581
]
|
4 | 0.83 ms |
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:
[
1356
]
|
5 | 0.43 ms |
SELECT t0.id AS id_1, t0.note AS note_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.ht_item_id AS ht_item_id_5, t0.ht_escandallo_id AS ht_escandallo_id_6, t0.created_id_id AS created_id_id_7, t0.updated_id_id AS updated_id_id_8 FROM ht_note t0 WHERE t0.ht_escandallo_id = ?
Parameters:
[
5
]
|
6 | 0.29 ms |
SELECT t0.id AS id_1, t0.note AS note_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.ht_item_id AS ht_item_id_5, t0.ht_escandallo_id AS ht_escandallo_id_6, t0.created_id_id AS created_id_id_7, t0.updated_id_id AS updated_id_id_8 FROM ht_note t0 WHERE t0.ht_escandallo_id = ?
Parameters:
[
18
]
|
7 | 0.28 ms |
SELECT t0.id AS id_1, t0.note AS note_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.ht_item_id AS ht_item_id_5, t0.ht_escandallo_id AS ht_escandallo_id_6, t0.created_id_id AS created_id_id_7, t0.updated_id_id AS updated_id_id_8 FROM ht_note t0 WHERE t0.ht_escandallo_id = ?
Parameters:
[
180
]
|
8 | 0.26 ms |
SELECT t0.id AS id_1, t0.note AS note_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.ht_item_id AS ht_item_id_5, t0.ht_escandallo_id AS ht_escandallo_id_6, t0.created_id_id AS created_id_id_7, t0.updated_id_id AS updated_id_id_8 FROM ht_note t0 WHERE t0.ht_escandallo_id = ?
Parameters:
[
199
]
|
9 | 0.24 ms |
SELECT t0.id AS id_1, t0.note AS note_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.ht_item_id AS ht_item_id_5, t0.ht_escandallo_id AS ht_escandallo_id_6, t0.created_id_id AS created_id_id_7, t0.updated_id_id AS updated_id_id_8 FROM ht_note t0 WHERE t0.ht_escandallo_id = ?
Parameters:
[
322
]
|
10 | 0.29 ms |
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.ht_item_id = ?
Parameters:
[
1584
]
|
11 | 0.52 ms |
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:
[
1357
]
|
12 | 0.32 ms |
SELECT t0.id AS id_1, t0.note AS note_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.ht_item_id AS ht_item_id_5, t0.ht_escandallo_id AS ht_escandallo_id_6, t0.created_id_id AS created_id_id_7, t0.updated_id_id AS updated_id_id_8 FROM ht_note t0 WHERE t0.ht_escandallo_id = ?
Parameters:
[
14
]
|
13 | 0.28 ms |
SELECT t0.id AS id_1, t0.note AS note_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.ht_item_id AS ht_item_id_5, t0.ht_escandallo_id AS ht_escandallo_id_6, t0.created_id_id AS created_id_id_7, t0.updated_id_id AS updated_id_id_8 FROM ht_note t0 WHERE t0.ht_escandallo_id = ?
Parameters:
[
17
]
|
14 | 0.25 ms |
SELECT t0.id AS id_1, t0.note AS note_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.ht_item_id AS ht_item_id_5, t0.ht_escandallo_id AS ht_escandallo_id_6, t0.created_id_id AS created_id_id_7, t0.updated_id_id AS updated_id_id_8 FROM ht_note t0 WHERE t0.ht_escandallo_id = ?
Parameters:
[
30
]
|
15 | 0.27 ms |
SELECT t0.id AS id_1, t0.note AS note_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.ht_item_id AS ht_item_id_5, t0.ht_escandallo_id AS ht_escandallo_id_6, t0.created_id_id AS created_id_id_7, t0.updated_id_id AS updated_id_id_8 FROM ht_note t0 WHERE t0.ht_escandallo_id = ?
Parameters:
[
38
]
|
16 | 0.25 ms |
SELECT t0.id AS id_1, t0.note AS note_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.ht_item_id AS ht_item_id_5, t0.ht_escandallo_id AS ht_escandallo_id_6, t0.created_id_id AS created_id_id_7, t0.updated_id_id AS updated_id_id_8 FROM ht_note t0 WHERE t0.ht_escandallo_id = ?
Parameters:
[
63
]
|
17 | 0.21 ms |
SELECT t0.id AS id_1, t0.note AS note_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.ht_item_id AS ht_item_id_5, t0.ht_escandallo_id AS ht_escandallo_id_6, t0.created_id_id AS created_id_id_7, t0.updated_id_id AS updated_id_id_8 FROM ht_note t0 WHERE t0.ht_escandallo_id = ?
Parameters:
[
66
]
|
18 | 0.20 ms |
SELECT t0.id AS id_1, t0.note AS note_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.ht_item_id AS ht_item_id_5, t0.ht_escandallo_id AS ht_escandallo_id_6, t0.created_id_id AS created_id_id_7, t0.updated_id_id AS updated_id_id_8 FROM ht_note t0 WHERE t0.ht_escandallo_id = ?
Parameters:
[
91
]
|
19 | 0.19 ms |
SELECT t0.id AS id_1, t0.note AS note_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.ht_item_id AS ht_item_id_5, t0.ht_escandallo_id AS ht_escandallo_id_6, t0.created_id_id AS created_id_id_7, t0.updated_id_id AS updated_id_id_8 FROM ht_note t0 WHERE t0.ht_escandallo_id = ?
Parameters:
[
109
]
|
20 | 0.23 ms |
SELECT t0.id AS id_1, t0.note AS note_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.ht_item_id AS ht_item_id_5, t0.ht_escandallo_id AS ht_escandallo_id_6, t0.created_id_id AS created_id_id_7, t0.updated_id_id AS updated_id_id_8 FROM ht_note t0 WHERE t0.ht_escandallo_id = ?
Parameters:
[
132
]
|
21 | 0.20 ms |
SELECT t0.id AS id_1, t0.note AS note_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.ht_item_id AS ht_item_id_5, t0.ht_escandallo_id AS ht_escandallo_id_6, t0.created_id_id AS created_id_id_7, t0.updated_id_id AS updated_id_id_8 FROM ht_note t0 WHERE t0.ht_escandallo_id = ?
Parameters:
[
151
]
|
22 | 0.19 ms |
SELECT t0.id AS id_1, t0.note AS note_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.ht_item_id AS ht_item_id_5, t0.ht_escandallo_id AS ht_escandallo_id_6, t0.created_id_id AS created_id_id_7, t0.updated_id_id AS updated_id_id_8 FROM ht_note t0 WHERE t0.ht_escandallo_id = ?
Parameters:
[
154
]
|
23 | 0.22 ms |
SELECT t0.id AS id_1, t0.note AS note_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.ht_item_id AS ht_item_id_5, t0.ht_escandallo_id AS ht_escandallo_id_6, t0.created_id_id AS created_id_id_7, t0.updated_id_id AS updated_id_id_8 FROM ht_note t0 WHERE t0.ht_escandallo_id = ?
Parameters:
[
179
]
|
24 | 0.20 ms |
SELECT t0.id AS id_1, t0.note AS note_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.ht_item_id AS ht_item_id_5, t0.ht_escandallo_id AS ht_escandallo_id_6, t0.created_id_id AS created_id_id_7, t0.updated_id_id AS updated_id_id_8 FROM ht_note t0 WHERE t0.ht_escandallo_id = ?
Parameters:
[
241
]
|
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\HtFile | No errors. |
App\Entity\Client | No errors. |
App\MDS\EventsBundle\Entity\Proposal | No errors. |
App\Entity\User | No errors. |
App\Entity\ClientContact | No errors. |
App\MDS\GreenPatioBundle\Entity\Reservation | No errors. |
App\Entity\HtItem |
|
App\Entity\HtVisit | No errors. |
App\MDS\GreenPatioBundle\Entity\ReservationService | No errors. |
App\MDS\GreenPatioBundle\Entity\ReservationLoungeDetails | No errors. |
App\Entity\HtMenu |
|
App\Entity\HtExtra | No errors. |
App\Entity\HtNote | No errors. |
App\Entity\Escandallo | No errors. |
App\Entity\FamilyEscandallo | No errors. |
App\Entity\EscandalloProduct | No errors. |