Query Metrics
18
Database Queries
14
Different statements
10.65 ms
Query time
2
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.26 ms |
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"
]
|
| 2 | 0.33 ms |
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"
]
|
| 3 | 0.46 ms |
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.id = ?
Parameters:
[
"4086"
]
|
| 4 | 0.32 ms |
SELECT t0.id AS id_1, t0.lounge_other AS lounge_other_2, t0.date_start AS date_start_3, t0.hour_end AS hour_end_4, t0.gratitudes AS gratitudes_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.pax AS pax_8, t0.observation AS observation_9, t0.type AS type_10, t0.reservation_service_id AS reservation_service_id_11, t0.lounge_gp_id AS lounge_gp_id_12, t0.created_id_id AS created_id_id_13, t0.updated_id_id AS updated_id_id_14, t0.ht_file_id AS ht_file_id_15 FROM ht_item t0 WHERE t0.ht_file_id = ?
Parameters:
[
4086
]
|
| 5 | 0.41 ms |
SELECT t0.id AS id_1, t0.client_id AS client_id_2, t0.position AS position_3, t0.department AS department_4, t0.type_client AS type_client_5, t0.name AS name_6, t0.last_name AS last_name_7, t0.email AS email_8, t0.password AS password_9, t0.token AS token_10, t0.phone AS phone_11, t0.mobile AS mobile_12, t0.birthday AS birthday_13, t0.assigned_agent AS assigned_agent_14, t0.situation AS situation_15, t0.status AS status_16, t0.created_id AS created_id_17, t0.created_at AS created_at_18, t0.updated_id AS updated_id_19, t0.updated_at AS updated_at_20, t0.picture AS picture_21, t0.newsletter AS newsletter_22 FROM clients_contact t0 WHERE t0.id = ?
Parameters:
[
3831
]
|
| 6 | 0.38 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.title AS title_4, t0.address AS address_5, t0.address_number AS address_number_6, t0.zip_code AS zip_code_7, t0.population AS population_8, t0.province AS province_9, t0.region AS region_10, t0.country AS country_11, t0.telephone AS telephone_12, t0.fax AS fax_13, t0.email AS email_14, t0.gds AS gds_15, t0.type_document AS type_document_16, t0.id_document AS id_document_17, t0.observation AS observation_18, t0.id_office AS id_office_19, t0.created_at AS created_at_20, t0.created_id AS created_id_21, t0.updated_at AS updated_at_22, t0.updated_id AS updated_id_23, t0.status AS status_24, t0.picture AS picture_25, t0.group_id AS group_id_26, t0.competency AS competency_27, t0.action AS action_28, t0.return_investment AS return_investment_29, t0.is_client_in_out AS is_client_in_out_30, t0.is_client_green_patio AS is_client_green_patio_31, t0.is_client_av_express AS is_client_av_express_32, t0.is_client_develup AS is_client_develup_33, t0.typology AS typology_34 FROM clients t0 WHERE t0.id = ?
Parameters:
[
5403
]
|
| 7 | 0.30 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:
[
35
]
|
| 8 | 0.82 ms |
SELECT t0.id AS id_1, t0.concept AS concept_2, t0.price AS price_3, t0.vat AS vat_4, t0.appear_invoice AS appear_invoice_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.hours AS hours_8, t0.quantity AS quantity_9, t0.over_commission AS over_commission_10, t0.op_over_commission AS op_over_commission_11, t0.ht_item_id AS ht_item_id_12, t0.ht_menu_id AS ht_menu_id_13, t0.created_id_id AS created_id_id_14, t0.updated_id_id AS updated_id_id_15 FROM ht_extra t0 WHERE t0.ht_item_id = ?
Parameters:
[
2327
]
|
| 9 | 0.32 ms |
SELECT c0_.id AS id_0, c0_.client_id AS client_id_1, c0_.position AS position_2, c0_.department AS department_3, c0_.type_client AS type_client_4, c0_.name AS name_5, c0_.last_name AS last_name_6, c0_.email AS email_7, c0_.password AS password_8, c0_.token AS token_9, c0_.phone AS phone_10, c0_.mobile AS mobile_11, c0_.birthday AS birthday_12, c0_.assigned_agent AS assigned_agent_13, c0_.situation AS situation_14, c0_.status AS status_15, c0_.created_id AS created_id_16, c0_.created_at AS created_at_17, c0_.updated_id AS updated_id_18, c0_.updated_at AS updated_at_19, c0_.picture AS picture_20, c0_.newsletter AS newsletter_21 FROM clients_contact c0_ WHERE c0_.id IN (?)
Parameters:
[
"3831"
]
|
| 10 | 0.36 ms |
SELECT c0_.id AS id_0, c0_.type AS type_1, c0_.name AS name_2, c0_.title AS title_3, c0_.address AS address_4, c0_.address_number AS address_number_5, c0_.zip_code AS zip_code_6, c0_.population AS population_7, c0_.province AS province_8, c0_.region AS region_9, c0_.country AS country_10, c0_.telephone AS telephone_11, c0_.fax AS fax_12, c0_.email AS email_13, c0_.gds AS gds_14, c0_.type_document AS type_document_15, c0_.id_document AS id_document_16, c0_.observation AS observation_17, c0_.id_office AS id_office_18, c0_.created_at AS created_at_19, c0_.created_id AS created_id_20, c0_.updated_at AS updated_at_21, c0_.updated_id AS updated_id_22, c0_.status AS status_23, c0_.picture AS picture_24, c0_.group_id AS group_id_25, c0_.competency AS competency_26, c0_.action AS action_27, c0_.return_investment AS return_investment_28, c0_.is_client_in_out AS is_client_in_out_29, c0_.is_client_green_patio AS is_client_green_patio_30, c0_.is_client_av_express AS is_client_av_express_31, c0_.is_client_develup AS is_client_develup_32, c0_.typology AS typology_33 FROM clients c0_ WHERE c0_.id IN (?)
Parameters:
[
"5403"
]
|
| 11 | 0.35 ms |
SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.created_id AS created_id_2, r0_.created_at AS created_at_3, r0_.updated_id AS updated_id_4, r0_.updated_at AS updated_at_5, r0_.meters AS meters_6, r0_.length AS length_7, r0_.width AS width_8, r0_.height AS height_9, r0_.cap_school AS cap_school_10, r0_.cap_theater AS cap_theater_11, r0_.cap_cocktail AS cap_cocktail_12, r0_.cap_banquet AS cap_banquet_13, r0_.cap_imperial AS cap_imperial_14, r0_.rank_lounge AS rank_lounge_15, r0_.combo AS combo_16, r0_.importantDescription AS importantDescription_17, r0_.importantDescGeneralText AS importantDescGeneralText_18, r0_.importantDescSchedules AS importantDescSchedules_19, r0_.importantDescParking AS importantDescParking_20 FROM reservation_lounge_details r0_ WHERE r0_.id IN (?)
Parameters:
[
"35"
]
|
| 12 | 0.31 ms |
SELECT t0.id AS id_1, t0.concept AS concept_2, t0.price AS price_3, t0.vat AS vat_4, t0.appear_invoice AS appear_invoice_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.hours AS hours_8, t0.quantity AS quantity_9, t0.over_commission AS over_commission_10, t0.op_over_commission AS op_over_commission_11, t0.ht_item_id AS ht_item_id_12, t0.ht_menu_id AS ht_menu_id_13, t0.created_id_id AS created_id_id_14, t0.updated_id_id AS updated_id_id_15 FROM ht_extra t0 WHERE t0.ht_item_id = ?
Parameters:
[
2327
]
|
| 13 | 0.41 ms |
"START TRANSACTION"
Parameters:
[] |
| 14 | 0.54 ms |
INSERT INTO ht_extra (concept, price, vat, appear_invoice, created_at, updated_at, hours, quantity, over_commission, op_over_commission, ht_item_id, ht_menu_id, created_id_id, updated_id_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "Transporte" 150.0 21.0 1 "2026-01-16 08:05:57" "2026-01-16 08:05:57" null null 0.0 1 2327 null 149 149 ] |
| 15 | 0.35 ms |
INSERT INTO ht_extra (concept, price, vat, appear_invoice, created_at, updated_at, hours, quantity, over_commission, op_over_commission, ht_item_id, ht_menu_id, created_id_id, updated_id_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "Montaje y desmontaje" 350.0 21.0 1 "2026-01-16 08:05:57" "2026-01-16 08:05:57" null null 0.0 1 2327 null 149 149 ] |
| 16 | 0.37 ms |
UPDATE ht_extra SET ht_item_id = ?, updated_at = ? WHERE id = ?
Parameters:
[ null "2026-01-16 08:05:57" 5683 ] |
| 17 | 0.28 ms |
UPDATE ht_extra SET ht_item_id = ?, updated_at = ? WHERE id = ?
Parameters:
[ null "2026-01-16 08:05:57" 5684 ] |
| 18 | 3.06 ms |
"COMMIT"
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\Entity\HtFile | No errors. |
| App\Entity\Client | No errors. |
| App\MDS\EventsBundle\Entity\Proposal | No errors. |
| App\Entity\ClientContact | No errors. |
| App\MDS\GreenPatioBundle\Entity\Reservation | 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. |
| App\Entity\ReservationLoungeWebDescription | No errors. |