https://mantevenues.mante.solutions/higotrigo/ht/file/htexternal/1/summary

Query Metrics

7 Database Queries
6 Different statements
3.74 ms Query time
3 Invalid entities

Queries

Group similar statements

# Time Info
1 0.83 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_team AS id_team_16, t0.team_leader AS team_leader_17, t0.role AS role_18, t0.access_key AS access_key_19, t0.language AS language_20, t0.color AS color_21, t0.sidebar AS sidebar_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.description AS description_25, t0.job_title AS job_title_26, t0.id_user_rol AS id_user_rol_27 FROM users t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "eduardo.pagola@develup.solutions"
]
2 0.39 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_team AS id_team_16, t0.team_leader AS team_leader_17, t0.role AS role_18, t0.access_key AS access_key_19, t0.language AS language_20, t0.color AS color_21, t0.sidebar AS sidebar_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.description AS description_25, t0.job_title AS job_title_26, t0.id_user_rol AS id_user_rol_27 FROM users t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "eduardo.pagola@develup.solutions"
]
3 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.billing_series AS billing_series_3, t0.is_main AS is_main_4, t0.rectifying_billing_series AS rectifying_billing_series_5, t0.iva AS iva_6 FROM space t0 ORDER BY t0.name ASC
Parameters:
[]
4 0.91 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.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:
[
  "1"
]
5 0.41 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:
[
  1
]
6 0.43 ms
SELECT t0.id AS id_1, t0.beneficio AS beneficio_2, t0.total_price AS total_price_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.template AS template_6, t0.name AS name_7, t0.iva AS iva_8, t0.created_id_id AS created_id_id_9, t0.updated_id_id AS updated_id_id_10, t0.ht_item_id AS ht_item_id_11 FROM ht_menu t0 WHERE t0.ht_item_id = ?
Parameters:
[
  3
]
7 0.39 ms
SELECT t0.id AS id_1, t0.access_type AS access_type_2, t0.name AS name_3, t0.primary_color AS primary_color_4, t0.secondary_color AS secondary_color_5, t0.accent_color AS accent_color_6, t0.logo_path AS logo_path_7, t0.is_active AS is_active_8 FROM settings_branding t0 WHERE t0.access_type = ? LIMIT 1
Parameters:
[
  "catering"
]

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\SettingsRol No errors.
App\Entity\UserNotification No errors.
App\Entity\ManteApp No errors.
App\Entity\Configuration No errors.
App\Entity\Space No errors.
App\MDS\VenuesBundle\Entity\ReservationLoungeDetails No errors.
App\Entity\HtFile No errors.
App\Entity\Client
  • The mappings App\Entity\Client#sagePayments and App\Entity\SagePayment#client are inconsistent with each other.
App\Entity\ClientContact No errors.
App\MDS\VenuesBundle\Entity\Reservation No errors.
App\Entity\HtItem
  • The association App\Entity\HtItem#loungeGp refers to the inverse side field App\MDS\VenuesBundle\Entity\ReservationLoungeDetails#htItems which does not exist.
  • The mappings App\Entity\HtItem#htMenus and App\Entity\HtMenu#htItem are inconsistent with each other.
App\Entity\HtVisit No errors.
App\MDS\VenuesBundle\Entity\ReservationService 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.
App\Entity\SettingsBranding No errors.