Query Metrics
76
Database Queries
16
Different statements
74.85 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
26.62 ms (35.56%) |
12 |
"COMMIT"
Parameters:
[] |
|
11.80 ms (15.76%) |
6 |
SELECT t0.id AS id_1, t0.contractual_document AS contractual_document_2, t0.company_id AS company_id_3, t0.model_id AS model_id_4, t0.file_id AS file_id_5, t0.client_id AS client_id_6, t0.created_at AS created_at_7, t0.created_id AS created_id_8, t0.updated_at AS updated_at_9, t0.updated_id AS updated_id_10, t0.date_at AS date_at_11, t0.booking_data AS booking_data_12, t0.client_proxy AS client_proxy_13, t0.client_job AS client_job_14 FROM doc_contract t0 WHERE t0.company_id = ? AND t0.file_id = ? AND t0.model_id = ?
Parameters:
[ 7 "14695" 16 ] |
|
7.79 ms (10.41%) |
1 |
UPDATE ave_files SET dateStart = ?, dateEnd = ? WHERE id = ?
Parameters:
[ "2026-02-25 00:00:00" "2026-02-25 00:00:00" 8448 ] |
|
4.66 ms (6.22%) |
6 |
UPDATE reservation_lounge_simple SET dateStart = ?, dateEnd = ?, idReservation = ?, pax = ?, op_iva = ?, updatedAt = ? WHERE id = ?
Parameters:
[ "2026-02-25 00:00:00" "2026-02-25 00:00:00" "14695" 0 1 "2026-02-04 07:34:41" 21407 ] |
|
4.07 ms (5.43%) |
7 |
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:
[
"14695"
]
|
|
3.92 ms (5.23%) |
6 |
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.id = ? LIMIT 1
Parameters:
[
21407
]
|
|
3.06 ms (4.09%) |
12 |
"START TRANSACTION"
Parameters:
[] |
|
2.66 ms (3.55%) |
6 |
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:
[
"Combo 1 Plenaria Imprenta + Invernadero"
]
|
|
2.42 ms (3.24%) |
6 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.client AS client_3, t0.priority AS priority_4, t0.supplier AS supplier_5, t0.status AS status_6, t0.daysBlock AS daysBlock_7, t0.advancePayment AS advancePayment_8, t0.idProposal AS idProposal_9, t0.cateringName AS cateringName_10, t0.boolCatering AS boolCatering_11, t0.dateStart AS dateStart_12, t0.dateEnd AS dateEnd_13, t0.pax AS pax_14, t0.deposit AS deposit_15, t0.access_key AS access_key_16, t0.description AS description_17, t0.destinoId AS destinoId_18, t0.createdAt AS createdAt_19, t0.createdId AS createdId_20, t0.updatedAt AS updatedAt_21, t0.updatedId AS updatedId_22, t0.comments AS comments_23, t0.comments_in_inv AS comments_in_inv_24, t0.comments_in_pro AS comments_in_pro_25, t0.xtra_field_one AS xtra_field_one_26, t0.xtra_field_two AS xtra_field_two_27, t0.reservation_id AS reservation_id_28 FROM ave_files t0 WHERE t0.reservation_id = ? LIMIT 1
Parameters:
[
14695
]
|
|
2.21 ms (2.95%) |
6 |
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 = ? LIMIT 1
Parameters:
[
14695
]
|
|
2.11 ms (2.82%) |
2 |
UPDATE reservation SET dateStart = ?, dateEnd = ? WHERE id = ?
Parameters:
[ "2999-01-01 00:00:00" "2000-01-01 00:00:00" 14695 ] |
|
1.39 ms (1.85%) |
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:
[
"ana.martin@greenpatio.es"
]
|
|
0.68 ms (0.91%) |
1 |
UPDATE ht_file SET date_start = ?, date_end = ?, updated_at = ? WHERE id = ?
Parameters:
[ "2026-02-25 00:00:00" "2026-02-25 00:00:00" "2026-02-04 07:34:41" 4611 ] |
|
0.58 ms (0.77%) |
1 |
UPDATE reservation SET dateEnd = ? WHERE id = ?
Parameters:
[ "2026-02-26 00:00:00" 14695 ] |
|
0.52 ms (0.70%) |
1 |
UPDATE ht_file SET date_end = ?, updated_at = ? WHERE id = ?
Parameters:
[ "2026-02-26 00:00:00" "2026-02-04 07:34:41" 4611 ] |
|
0.38 ms (0.50%) |
1 |
UPDATE ave_files SET dateEnd = ? WHERE id = ?
Parameters:
[ "2026-02-26 00:00:00" 8448 ] |
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\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\GpReminder | No errors. |
| App\Entity\HtItem |
|
| App\Entity\HtVisit | No errors. |
| App\MDS\GreenPatioBundle\Entity\ReservationLoungeSimple | No errors. |
| App\MDS\GreenPatioBundle\Entity\ReservationLoungeDetails | No errors. |
| App\Entity\ReservationLoungeWebDescription | No errors. |
| App\MDS\AvexpressBundle\Entity\AveFiles | No errors. |
| App\Entity\DocContract | No errors. |