Query Metrics
46
Database Queries
8
Different statements
11.36 ms
Query time
2
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
3.95 ms (34.80%) |
24 |
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
]
|
|
2.22 ms (19.56%) |
8 |
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:
[
2294
]
|
|
1.84 ms (16.18%) |
8 |
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:
[
2473
]
|
|
1.19 ms (10.48%) |
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:
[
"3521"
]
|
|
0.73 ms (6.43%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.client AS client_3, t0.clientContact AS clientContact_4, t0.contactUnregistered AS contactUnregistered_5, t0.nameContactUnregistered AS nameContactUnregistered_6, t0.phoneContactUnregistered AS phoneContactUnregistered_7, t0.days AS days_8, t0.createdAt AS createdAt_9, t0.priority AS priority_10, t0.createdBy AS createdBy_11, t0.supplier AS supplier_12, t0.status AS status_13, t0.updatedAt AS updatedAt_14, t0.updatedBy AS updatedBy_15, t0.daysBlock AS daysBlock_16, t0.advancePayment AS advancePayment_17, t0.idProposal AS idProposal_18, t0.cateringName AS cateringName_19, t0.boolCatering AS boolCatering_20, t0.dateStart AS dateStart_21, t0.dateEnd AS dateEnd_22, t0.pax AS pax_23, t0.deposit AS deposit_24, t0.access_key AS access_key_25, t0.description AS description_26, t0.contract AS contract_27, t0.token AS token_28, t0.comAvGp AS comAvGp_29, t0.comHtGp AS comHtGp_30, t0.infoFormWeb AS infoFormWeb_31, t32.id AS id_33, t32.title AS title_34, t32.status AS status_35, t32.days_block AS days_block_36, t32.pax AS pax_37, t32.description AS description_38, t32.description_two AS description_two_39, t32.contact_unregistered AS contact_unregistered_40, t32.name_contact_unregistered AS name_contact_unregistered_41, t32.phone_contact_unregistered AS phone_contact_unregistered_42, t32.date_start AS date_start_43, t32.date_end AS date_end_44, t32.created_at AS created_at_45, t32.updated_at AS updated_at_46, t32.client_type AS client_type_47, t32.client_id AS client_id_48, t32.proposal_id AS proposal_id_49, t32.created_id_id AS created_id_id_50, t32.updated_id_id AS updated_id_id_51, t32.client_contact_id AS client_contact_id_52, t32.reservation_id AS reservation_id_53 FROM reservation t0 LEFT JOIN ht_file t32 ON t32.reservation_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
13640
]
|
|
0.59 ms (5.19%) |
2 |
SELECT t0.id AS id_1, t0.loungeName AS loungeName_2, t0.idLounge AS idLounge_3, t0.dateStart AS dateStart_4, t0.dateEnd AS dateEnd_5, t0.servicePrice AS servicePrice_6, t0.idReservation AS idReservation_7, t0.pax AS pax_8, t0.type AS type_9, t0.createdAt AS createdAt_10, t0.createdBy AS createdBy_11, t0.updatedAt AS updatedAt_12, t0.updatedBy AS updatedBy_13, t0.hourStart AS hourStart_14, t0.minStart AS minStart_15, t0.hourEnd AS hourEnd_16, t0.minEnd AS minEnd_17, t0.rankQuote AS rankQuote_18, t0.op_iva AS op_iva_19, t0.iva AS iva_20, t0.loungeDescription AS loungeDescription_21, t0.importantDescription AS importantDescription_22, t0.importantDescGeneralText AS importantDescGeneralText_23, t0.importantDescSchedules AS importantDescSchedules_24, t0.importantDescParking AS importantDescParking_25, t0.language AS language_26 FROM reservation_lounge_simple t0 WHERE t0.idReservation = ? AND t0.type = ? LIMIT 1
Parameters:
[ 13640 "Montaje" ] |
|
0.42 ms (3.69%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_id AS created_id_3, t0.created_at AS created_at_4, t0.updated_id AS updated_id_5, t0.updated_at AS updated_at_6, t0.meters AS meters_7, t0.length AS length_8, t0.width AS width_9, t0.height AS height_10, t0.cap_school AS cap_school_11, t0.cap_theater AS cap_theater_12, t0.cap_cocktail AS cap_cocktail_13, t0.cap_banquet AS cap_banquet_14, t0.cap_imperial AS cap_imperial_15, t0.rank_lounge AS rank_lounge_16, t0.combo AS combo_17, t0.importantDescription AS importantDescription_18, t0.importantDescGeneralText AS importantDescGeneralText_19, t0.importantDescSchedules AS importantDescSchedules_20, t0.importantDescParking AS importantDescParking_21 FROM reservation_lounge_details t0 WHERE t0.id = ?
Parameters:
[
25
]
|
|
0.42 ms (3.67%) |
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:
[
3521
]
|
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\ReservationLoungeWebDescription | No errors. |
| App\Entity\Escandallo | No errors. |
| App\Entity\FamilyEscandallo | No errors. |
| App\Entity\EscandalloProduct | No errors. |
| App\Entity\GpReminder | No errors. |
| App\MDS\GreenPatioBundle\Entity\ReservationLoungeSimple | No errors. |