Query Metrics
133
Database Queries
8
Different statements
2645.80 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2378.70 ms (89.90%) |
63 |
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 = ? LIMIT 1
Parameters:
[
14058
]
|
|
117.63 ms (4.45%) |
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.createdBy = ? AND t0.status IN (?, ?, ?)
Parameters:
[ 149 "Bloqueo" "Confirmed" "Cotizado" ] |
|
95.96 ms (3.63%) |
1 |
SELECT r0_.id AS id_0, r0_.title AS title_1, r0_.client AS client_2, r0_.clientContact AS clientContact_3, r0_.contactUnregistered AS contactUnregistered_4, r0_.nameContactUnregistered AS nameContactUnregistered_5, r0_.phoneContactUnregistered AS phoneContactUnregistered_6, r0_.days AS days_7, r0_.createdAt AS createdAt_8, r0_.priority AS priority_9, r0_.createdBy AS createdBy_10, r0_.supplier AS supplier_11, r0_.status AS status_12, r0_.updatedAt AS updatedAt_13, r0_.updatedBy AS updatedBy_14, r0_.daysBlock AS daysBlock_15, r0_.advancePayment AS advancePayment_16, r0_.idProposal AS idProposal_17, r0_.cateringName AS cateringName_18, r0_.boolCatering AS boolCatering_19, r0_.dateStart AS dateStart_20, r0_.dateEnd AS dateEnd_21, r0_.pax AS pax_22, r0_.deposit AS deposit_23, r0_.access_key AS access_key_24, r0_.description AS description_25, r0_.contract AS contract_26, r0_.token AS token_27, r0_.comAvGp AS comAvGp_28, r0_.comHtGp AS comHtGp_29, r0_.infoFormWeb AS infoFormWeb_30 FROM reservation r0_ WHERE r0_.status = ? AND r0_.days > ?
Parameters:
[ "Bloqueo" "2026-01-15 08:19:12" ] |
|
48.71 ms (1.84%) |
63 |
SELECT t0.id AS id_1, t0.reservationId AS reservationId_2, t0.isDone AS isDone_3, t0.description AS description_4, t0.amount AS amount_5, t0.date AS date_6, t0.created_id AS created_id_7, t0.created_at AS created_at_8, t0.updated_id AS updated_id_9, t0.updated_at AS updated_at_10 FROM reservation_deposit t0 WHERE t0.reservationId = ? LIMIT 1
Parameters:
[
14058
]
|
|
1.80 ms (0.07%) |
1 |
SELECT u0_.id AS id_0, u0_.picture AS picture_1, u0_.username AS username_2, u0_.email AS email_3, u0_.password AS password_4, u0_.movil_password AS movil_password_5, u0_.pass_gmail AS pass_gmail_6, u0_.firm_gmail AS firm_gmail_7, u0_.name AS name_8, u0_.last_name AS last_name_9, u0_.telephone AS telephone_10, u0_.mobile AS mobile_11, u0_.id_office AS id_office_12, u0_.status AS status_13, u0_.id_company AS id_company_14, u0_.id_user_rol AS id_user_rol_15, u0_.id_team AS id_team_16, u0_.team_leader AS team_leader_17, u0_.role AS role_18, u0_.access_key AS access_key_19, u0_.language AS language_20, u0_.color AS color_21, u0_.vacations AS vacations_22, u0_.half_days AS half_days_23, u0_.sidebar AS sidebar_24, u0_.created_at AS created_at_25, u0_.updated_at AS updated_at_26, u0_.description AS description_27, u0_.job_title AS job_title_28 FROM users u0_
Parameters:
[] |
|
1.34 ms (0.05%) |
2 |
SELECT t0.id AS id_1, t0.picture AS picture_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.movil_password AS movil_password_6, t0.pass_gmail AS pass_gmail_7, t0.firm_gmail AS firm_gmail_8, t0.name AS name_9, t0.last_name AS last_name_10, t0.telephone AS telephone_11, t0.mobile AS mobile_12, t0.id_office AS id_office_13, t0.status AS status_14, t0.id_company AS id_company_15, t0.id_user_rol AS id_user_rol_16, t0.id_team AS id_team_17, t0.team_leader AS team_leader_18, t0.role AS role_19, t0.access_key AS access_key_20, t0.language AS language_21, t0.color AS color_22, t0.vacations AS vacations_23, t0.half_days AS half_days_24, t0.sidebar AS sidebar_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.description AS description_28, t0.job_title AS job_title_29 FROM users t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"fernanda.ortiz@greenpatio.es"
]
|
|
0.88 ms (0.03%) |
1 |
SELECT t0.id AS id_1, t0.reminder_at AS reminder_at_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.reminder AS reminder_5, t0.user_id AS user_id_6, t0.reservation_id AS reservation_id_7, t0.created_id_id AS created_id_id_8, t0.updated_id_id AS updated_id_id_9 FROM gp_reminder t0 WHERE t0.user_id = ?
Parameters:
[
149
]
|
|
0.78 ms (0.03%) |
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.reservation_id = ?
Parameters:
[
14364
]
|
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\User | No errors. |
| App\Entity\GpReminder | 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\ClientContact | No errors. |
| App\Entity\HtItem |
|
| App\Entity\HtVisit | No errors. |
| App\MDS\GreenPatioBundle\Entity\ReservationLoungeSimple | No errors. |
| App\MDS\GreenPatioBundle\Entity\ReservationDeposit | No errors. |