Query Metrics
11
Database Queries
8
Different statements
13.05 ms
Query time
1
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
5.25 ms (40.21%) |
1 |
UPDATE reservation SET clientContact = ?, contactUnregistered = ?, updatedAt = ?, updatedBy = ?, daysBlock = ?, advancePayment = ?, deposit = ?, description = ?, contract = ? WHERE id = ?
Parameters:
[ "" "raquel@neverenough.es" "2024-11-14 17:40:28" 127 "7" 0 0 "<blockquote type="cite" style="color: rgb(34, 34, 34); font-family: Arial, Helvetica, sans-serif; font-size: small;"><div dir="ltr"><div class="gmail_quote"><blockquote><blockquote type="cite"><div class="gmail_quote"><blockquote><blockquote type="cite"><div dir="ltr"><div dir="ltr"><div class="gmail_quote"><blockquote><div class="gmail_quote"><div><span style="color: rgb(51, 51, 51); font-family: Roboto, "Helvetica Neue", Helvetica, Arial, sans-serif;"> </span><span dir="auto" style="color: rgb(51, 51, 51); font-family: Roboto, "Helvetica Neue", Helvetica, Arial, sans-serif;"><a href="mailto:raquel@neverenough.es" rel="noopener" target="_blank" style="color: rgb(17, 85, 204);"><span class="il">raquel@neverenough.es</span></a></span></div><div><span dir="auto" style="color: rgb(51, 51, 51); font-family: Roboto, "Helvetica Neue", Helvetica, Arial, sans-serif;"><a href="mailto:raquel@neverenough.es" rel="noopener" target="_blank" style="color: rgb(17, 85, 204);"><span class="il"><br></span></a></span><strong>Fecha</strong>: 3 de diciembre 2024</div><div><strong>Horario</strong>: 9:00h-17:00h</div><div><strong>Pax</strong>: 36 personas</div><div><strong>Necesidades</strong>:<ul type="disc"><li class="MsoNormal" style="margin: 0px 0px 0px 15px;">Sala grande para plenaria 36 pax, pero que puedan ponerse en 4 mesas redondas en algún momento. Esto es lo más importante.</li><li class="MsoNormal" style="margin: 0px 0px 0px 15px;">Coffee break para 36 pax</li><li class="MsoNormal" style="margin: 0px 0px 0px 15px;">AAVV básicos: Pantalla + Proyección, megafonía básica y 4 mesas y sillas para todos (Por confirmar)</li><li class="MsoNormal" style="margin: 0px 0px 0px 15px;">Comida: Sala para taller de cocina externo o menú cóctel para comida, por confirmar. Tenéis o conocéis algún proveedor que pueda traer la actividad?</li></ul><strong>Horario</strong>:<div><ul type="disc"><li style="margin-left: 15px;">Welcome Coffee (9.00 – 9.30h)</li><li style="margin-left: 15px;">Ice Breaker (9.30 – 10h)</li><li style="margin-left: 15px;">Meeting (10-11h)</li><li style="margin-left: 15px;">Groups discusión (11-12h)</li><li style="margin-left: 15px;">Coffee break (12-12.30h)</li><li style="margin-left: 15px;">Sesión plenaria (12.30 – 13.30h)</li><li style="margin-left: 15px;">A partir de las 13.30h actividad comida para acabar sobre las 17 o 17.30h</li></ul></div><div>Necesitamos respuesta lo antes posible.</div></div></div></blockquote></div></div></div></blockquote></blockquote></div></blockquote></blockquote></div></div></blockquote>" "" 10487 ] |
3.67 ms (28.09%) |
1 |
"COMMIT"
Parameters:
[] |
1.34 ms (10.28%) |
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:
[
"maria.martinez@greenpatio.es"
]
|
1.27 ms (9.71%) |
3 |
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, t29.id AS id_30, t29.title AS title_31, t29.status AS status_32, t29.days_block AS days_block_33, t29.pax AS pax_34, t29.description AS description_35, t29.description_two AS description_two_36, t29.contact_unregistered AS contact_unregistered_37, t29.name_contact_unregistered AS name_contact_unregistered_38, t29.phone_contact_unregistered AS phone_contact_unregistered_39, t29.date_start AS date_start_40, t29.date_end AS date_end_41, t29.created_at AS created_at_42, t29.updated_at AS updated_at_43, t29.client_id AS client_id_44, t29.proposal_id AS proposal_id_45, t29.created_id_id AS created_id_id_46, t29.updated_id_id AS updated_id_id_47, t29.client_contact_id AS client_contact_id_48, t29.reservation_id AS reservation_id_49 FROM reservation t0 LEFT JOIN ht_file t29 ON t29.reservation_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
"10487"
]
|
0.59 ms (4.53%) |
1 |
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.id = ? LIMIT 1
Parameters:
[
127
]
|
0.38 ms (2.88%) |
1 |
SELECT t0.id AS id_1, t0.reservationId AS reservationId_2, t0.agentId AS agentId_3, t0.agentMail AS agentMail_4, t0.clientId AS clientId_5, t0.clientMail AS clientMail_6, t0.alertDateTime AS alertDateTime_7, t0.alertSended AS alertSended_8, t0.cancelDateTime AS cancelDateTime_9, t0.cancelSended AS cancelSended_10, t0.created_at AS created_at_11, t0.created_id AS created_id_12, t0.oldReservationId AS oldReservationId_13 FROM reservation_mail_alert_client t0 WHERE t0.reservationId = ? LIMIT 1
Parameters:
[
"10487"
]
|
0.37 ms (2.80%) |
1 |
SELECT t0.id AS id_1, t0.master AS master_2, t0.number AS number_3, t0.prefix AS prefix_4, t0.dateAt AS dateAt_5, t0.type AS type_6, t0.reservationId AS reservationId_7, t0.totalNet AS totalNet_8, t0.vat AS vat_9, t0.total AS total_10, t0.balance AS balance_11, t0.createdAt AS createdAt_12, t0.createdId AS createdId_13, t0.updatedAt AS updatedAt_14, t0.updatedId AS updatedId_15, t0.client_name AS client_name_16, t0.client_address AS client_address_17, t0.client_document AS client_document_18, t0.client_type AS client_type_19 FROM reservation_invoice t0 WHERE t0.reservationId = ?
Parameters:
[
"10487"
]
|
0.20 ms (1.49%) |
1 |
"START TRANSACTION"
Parameters:
[] |
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\ReservationInvoice | No errors. |
App\MDS\GreenPatioBundle\Entity\ReservationMailAlertClient | No errors. |