Query Metrics
2
Database Queries
2
Different statements
1.48 ms
Query time
2
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.96 ms |
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 = ?
Parameters:
[
"14156"
]
|
| 2 | 0.51 ms |
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:
[
"14156"
]
|
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\MDS\GreenPatioBundle\Entity\ReservationLoungeSimple | No errors. |
| App\MDS\GreenPatioBundle\Entity\Reservation | No 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\Entity\GpReminder | 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. |