Query Metrics
29
Database Queries
8
Different statements
5.49 ms
Query time
1
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.90 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, t31.id AS id_32, t31.title AS title_33, t31.status AS status_34, t31.days_block AS days_block_35, t31.pax AS pax_36, t31.description AS description_37, t31.description_two AS description_two_38, t31.contact_unregistered AS contact_unregistered_39, t31.name_contact_unregistered AS name_contact_unregistered_40, t31.phone_contact_unregistered AS phone_contact_unregistered_41, t31.date_start AS date_start_42, t31.date_end AS date_end_43, t31.created_at AS created_at_44, t31.updated_at AS updated_at_45, t31.client_type AS client_type_46, t31.client_id AS client_id_47, t31.proposal_id AS proposal_id_48, t31.created_id_id AS created_id_id_49, t31.updated_id_id AS updated_id_id_50, t31.client_contact_id AS client_contact_id_51, t31.reservation_id AS reservation_id_52 FROM reservation t0 LEFT JOIN ht_file t31 ON t31.reservation_id = t0.id WHERE t0.token = ? LIMIT 1
Parameters:
[
"685bdcaeb9f37"
]
|
| 2 | 0.34 ms |
SELECT t0.id AS id_1, t0.reservationId AS reservationId_2, t0.supplierId AS supplierId_3, t0.serviceId AS serviceId_4, t0.serviceCatId AS serviceCatId_5, t0.serviceCatName AS serviceCatName_6, t0.name AS name_7, t0.price AS price_8, t0.currency AS currency_9, t0.units AS units_10, t0.opCommission AS opCommission_11, t0.commission AS commission_12, t0.opOver AS opOver_13, t0.price_over AS price_over_14, t0.opIva AS opIva_15, t0.iva AS iva_16, t0.pax AS pax_17, t0.hour AS hour_18, t0.dateInAt AS dateInAt_19, t0.dateOutAt AS dateOutAt_20, t0.contcolor AS contcolor_21, t0.`rank` AS rank_22, t0.assistantId AS assistantId_23, t0.activityId AS activityId_24, t0.pay AS pay_25, t0.createdAt AS createdAt_26, t0.createdId AS createdId_27, t0.updatedAt AS updatedAt_28, t0.updatedId AS updatedId_29, t0.toinvoice AS toinvoice_30, t0.viewInfo AS viewInfo_31, t32.id AS id_33, t32.lounge_other AS lounge_other_34, t32.date_start AS date_start_35, t32.hour_end AS hour_end_36, t32.gratitudes AS gratitudes_37, t32.created_at AS created_at_38, t32.updated_at AS updated_at_39, t32.pax AS pax_40, t32.observation AS observation_41, t32.type AS type_42, t32.reservation_service_id AS reservation_service_id_43, t32.lounge_gp_id AS lounge_gp_id_44, t32.created_id_id AS created_id_id_45, t32.updated_id_id AS updated_id_id_46, t32.ht_file_id AS ht_file_id_47 FROM reservation_service t0 LEFT JOIN ht_item t32 ON t32.reservation_service_id = t0.id WHERE t0.reservationId = ?
Parameters:
[
12311
]
|
| 3 | 0.39 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:
[
12311
]
|
| 4 | 0.18 ms |
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.name = ? LIMIT 1
Parameters:
[
"Sala White en exclusiva"
]
|
| 5 | 0.22 ms |
SELECT t0.id AS id_1, t0.loungeId AS loungeId_2, t0.language AS language_3, t0.description AS description_4, t0.createdId AS createdId_5, t0.createdAt AS createdAt_6, t0.updatedId AS updatedId_7, t0.updatedAt AS updatedAt_8 FROM reservation_lounge_description t0 WHERE t0.loungeId = ?
Parameters:
[
24
]
|
| 6 | 0.38 ms |
SELECT t0.id AS id_1, t0.loungeId AS loungeId_2, t0.createdId AS createdId_3, t0.createdAt AS createdAt_4, t0.updatedId AS updatedId_5, t0.updatedAt AS updatedAt_6, t0.title AS title_7, t0.image_large AS image_large_8, t0.image_medium AS image_medium_9, t0.image_small AS image_small_10 FROM reservation_lounge_picture t0 WHERE t0.loungeId = ?
Parameters:
[
24
]
|
| 7 | 0.20 ms |
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:
[
"22"
]
|
| 8 | 0.16 ms |
SELECT t0.id AS id_1, t0.loungeId AS loungeId_2, t0.language AS language_3, t0.description AS description_4, t0.createdId AS createdId_5, t0.createdAt AS createdAt_6, t0.updatedId AS updatedId_7, t0.updatedAt AS updatedAt_8 FROM reservation_lounge_description t0 WHERE t0.loungeId = ?
Parameters:
[
22
]
|
| 9 | 0.15 ms |
SELECT t0.id AS id_1, t0.loungeId AS loungeId_2, t0.createdId AS createdId_3, t0.createdAt AS createdAt_4, t0.updatedId AS updatedId_5, t0.updatedAt AS updatedAt_6, t0.title AS title_7, t0.image_large AS image_large_8, t0.image_medium AS image_medium_9, t0.image_small AS image_small_10 FROM reservation_lounge_picture t0 WHERE t0.loungeId = ?
Parameters:
[
22
]
|
| 10 | 0.18 ms |
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:
[
"23"
]
|
| 11 | 0.12 ms |
SELECT t0.id AS id_1, t0.loungeId AS loungeId_2, t0.language AS language_3, t0.description AS description_4, t0.createdId AS createdId_5, t0.createdAt AS createdAt_6, t0.updatedId AS updatedId_7, t0.updatedAt AS updatedAt_8 FROM reservation_lounge_description t0 WHERE t0.loungeId = ?
Parameters:
[
23
]
|
| 12 | 0.13 ms |
SELECT t0.id AS id_1, t0.loungeId AS loungeId_2, t0.createdId AS createdId_3, t0.createdAt AS createdAt_4, t0.updatedId AS updatedId_5, t0.updatedAt AS updatedAt_6, t0.title AS title_7, t0.image_large AS image_large_8, t0.image_medium AS image_medium_9, t0.image_small AS image_small_10 FROM reservation_lounge_picture t0 WHERE t0.loungeId = ?
Parameters:
[
23
]
|
| 13 | 0.16 ms |
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 = ? LIMIT 1
Parameters:
[
24
]
|
| 14 | 0.16 ms |
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.name = ? LIMIT 1
Parameters:
[
"Sala White en exclusiva"
]
|
| 15 | 0.13 ms |
SELECT t0.id AS id_1, t0.loungeId AS loungeId_2, t0.language AS language_3, t0.description AS description_4, t0.createdId AS createdId_5, t0.createdAt AS createdAt_6, t0.updatedId AS updatedId_7, t0.updatedAt AS updatedAt_8 FROM reservation_lounge_description t0 WHERE t0.loungeId = ?
Parameters:
[
24
]
|
| 16 | 0.14 ms |
SELECT t0.id AS id_1, t0.loungeId AS loungeId_2, t0.createdId AS createdId_3, t0.createdAt AS createdAt_4, t0.updatedId AS updatedId_5, t0.updatedAt AS updatedAt_6, t0.title AS title_7, t0.image_large AS image_large_8, t0.image_medium AS image_medium_9, t0.image_small AS image_small_10 FROM reservation_lounge_picture t0 WHERE t0.loungeId = ?
Parameters:
[
24
]
|
| 17 | 0.12 ms |
SELECT t0.id AS id_1, t0.loungeId AS loungeId_2, t0.language AS language_3, t0.description AS description_4, t0.createdId AS createdId_5, t0.createdAt AS createdAt_6, t0.updatedId AS updatedId_7, t0.updatedAt AS updatedAt_8 FROM reservation_lounge_description t0 WHERE t0.loungeId = ?
Parameters:
[
22
]
|
| 18 | 0.11 ms |
SELECT t0.id AS id_1, t0.loungeId AS loungeId_2, t0.createdId AS createdId_3, t0.createdAt AS createdAt_4, t0.updatedId AS updatedId_5, t0.updatedAt AS updatedAt_6, t0.title AS title_7, t0.image_large AS image_large_8, t0.image_medium AS image_medium_9, t0.image_small AS image_small_10 FROM reservation_lounge_picture t0 WHERE t0.loungeId = ?
Parameters:
[
22
]
|
| 19 | 0.10 ms |
SELECT t0.id AS id_1, t0.loungeId AS loungeId_2, t0.language AS language_3, t0.description AS description_4, t0.createdId AS createdId_5, t0.createdAt AS createdAt_6, t0.updatedId AS updatedId_7, t0.updatedAt AS updatedAt_8 FROM reservation_lounge_description t0 WHERE t0.loungeId = ?
Parameters:
[
23
]
|
| 20 | 0.12 ms |
SELECT t0.id AS id_1, t0.loungeId AS loungeId_2, t0.createdId AS createdId_3, t0.createdAt AS createdAt_4, t0.updatedId AS updatedId_5, t0.updatedAt AS updatedAt_6, t0.title AS title_7, t0.image_large AS image_large_8, t0.image_medium AS image_medium_9, t0.image_small AS image_small_10 FROM reservation_lounge_picture t0 WHERE t0.loungeId = ?
Parameters:
[
23
]
|
| 21 | 0.12 ms |
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 = ? LIMIT 1
Parameters:
[
24
]
|
| 22 | 0.12 ms |
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.name = ? LIMIT 1
Parameters:
[
"Sala Black"
]
|
| 23 | 0.11 ms |
SELECT t0.id AS id_1, t0.loungeId AS loungeId_2, t0.language AS language_3, t0.description AS description_4, t0.createdId AS createdId_5, t0.createdAt AS createdAt_6, t0.updatedId AS updatedId_7, t0.updatedAt AS updatedAt_8 FROM reservation_lounge_description t0 WHERE t0.loungeId = ?
Parameters:
[
25
]
|
| 24 | 0.11 ms |
SELECT t0.id AS id_1, t0.loungeId AS loungeId_2, t0.createdId AS createdId_3, t0.createdAt AS createdAt_4, t0.updatedId AS updatedId_5, t0.updatedAt AS updatedAt_6, t0.title AS title_7, t0.image_large AS image_large_8, t0.image_medium AS image_medium_9, t0.image_small AS image_small_10 FROM reservation_lounge_picture t0 WHERE t0.loungeId = ?
Parameters:
[
25
]
|
| 25 | 0.13 ms |
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 = ? LIMIT 1
Parameters:
[
25
]
|
| 26 | 0.12 ms |
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.name = ? LIMIT 1
Parameters:
[
"Sala Black"
]
|
| 27 | 0.11 ms |
SELECT t0.id AS id_1, t0.loungeId AS loungeId_2, t0.language AS language_3, t0.description AS description_4, t0.createdId AS createdId_5, t0.createdAt AS createdAt_6, t0.updatedId AS updatedId_7, t0.updatedAt AS updatedAt_8 FROM reservation_lounge_description t0 WHERE t0.loungeId = ?
Parameters:
[
25
]
|
| 28 | 0.16 ms |
SELECT t0.id AS id_1, t0.loungeId AS loungeId_2, t0.createdId AS createdId_3, t0.createdAt AS createdAt_4, t0.updatedId AS updatedId_5, t0.updatedAt AS updatedAt_6, t0.title AS title_7, t0.image_large AS image_large_8, t0.image_medium AS image_medium_9, t0.image_small AS image_small_10 FROM reservation_lounge_picture t0 WHERE t0.loungeId = ?
Parameters:
[
25
]
|
| 29 | 0.12 ms |
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 = ? LIMIT 1
Parameters:
[
25
]
|
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\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\MDS\GreenPatioBundle\Entity\ReservationLoungeSimple | No errors. |
| App\Entity\ReservationLoungeWebDescription | No errors. |
| App\MDS\GreenPatioBundle\Entity\ReservationLoungeDescription | No errors. |
| App\MDS\GreenPatioBundle\Entity\ReservationLoungePicture | No errors. |