Query Metrics
24
Database Queries
5
Different statements
8.79 ms
Query time
2
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
4.49 ms (51.13%) |
18 |
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
]
|
1.35 ms (15.32%) |
2 |
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
]
|
1.30 ms (14.76%) |
1 |
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"
]
|
0.91 ms (10.36%) |
2 |
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
]
|
0.74 ms (8.43%) |
1 |
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
]
|
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. |