https://inout.mante.solutions/higotrigo/ht/file/214/edit/ajax Return to referer URL

Query Metrics

35 Database Queries
12 Different statements
10.61 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
3.68 ms
(34.71%)
16
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:
[
  640
]
1.69 ms
(15.96%)
7
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 FROM reservation_lounge_details r0_ WHERE r0_.id IN (?)
Parameters:
[
  "19"
]
1.51 ms
(14.20%)
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:
[
  "gonzalo.alonso@higotrigo.com"
]
0.78 ms
(7.33%)
2
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 FROM reservation_lounge_details t0 WHERE t0.id = ?
Parameters:
[
  19
]
0.48 ms
(4.48%)
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_id AS client_id_15, t0.proposal_id AS proposal_id_16, t0.created_id_id AS created_id_id_17, t0.updated_id_id AS updated_id_id_18, t0.client_contact_id AS client_contact_id_19, t0.reservation_id AS reservation_id_20 FROM ht_file t0 WHERE t0.id = ?
Parameters:
[
  "214"
]
0.42 ms
(3.95%)
1
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
]
0.41 ms
(3.83%)
1
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:
[
  214
]
0.36 ms
(3.40%)
1
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"
]
0.36 ms
(3.39%)
1
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 FROM clients t0 WHERE t0.id = ?
Parameters:
[
  2718
]
0.35 ms
(3.29%)
1
"START TRANSACTION"
Parameters:
[]
0.33 ms
(3.12%)
1
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 FROM clients c0_ WHERE c0_.id IN (?)
Parameters:
[
  "2718"
]
0.25 ms
(2.35%)
1
"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
  • The mappings App\Entity\HtItem#htMenus and App\Entity\HtMenu#htItem are inconsistent with each other.
App\Entity\HtVisit No errors.
App\MDS\GreenPatioBundle\Entity\ReservationService No errors.
App\MDS\GreenPatioBundle\Entity\ReservationLoungeDetails No errors.
App\Entity\HtMenu
  • The association App\Entity\HtMenu#htItem refers to the inverse side field App\Entity\HtItem#htMenu which does not exist.
App\Entity\HtExtra No errors.
App\Entity\HtNote No errors.