Query Metrics
9
Database Queries
8
Different statements
68.69 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.69 ms |
SELECT t0.id AS id_1, t0.picture AS picture_2, t0.signature AS signature_3, t0.username AS username_4, t0.email AS email_5, t0.password AS password_6, t0.movil_password AS movil_password_7, t0.pass_gmail AS pass_gmail_8, t0.firm_gmail AS firm_gmail_9, t0.name AS name_10, t0.last_name AS last_name_11, t0.telephone AS telephone_12, t0.mobile AS mobile_13, t0.status AS status_14, t0.team_leader AS team_leader_15, t0.role AS role_16, t0.access_key AS access_key_17, t0.language AS language_18, t0.color AS color_19, t0.sidebar AS sidebar_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.description AS description_23, t0.job_title AS job_title_24, t0.reset_token AS reset_token_25, t0.id_office AS id_office_26, t0.id_company AS id_company_27, t0.id_user_rol AS id_user_rol_28, t0.id_team AS id_team_29 FROM users t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"admon@avexpress.tv"
]
|
| 2 | 0.37 ms |
SELECT t0.id AS id_1, t0.picture AS picture_2, t0.signature AS signature_3, t0.username AS username_4, t0.email AS email_5, t0.password AS password_6, t0.movil_password AS movil_password_7, t0.pass_gmail AS pass_gmail_8, t0.firm_gmail AS firm_gmail_9, t0.name AS name_10, t0.last_name AS last_name_11, t0.telephone AS telephone_12, t0.mobile AS mobile_13, t0.status AS status_14, t0.team_leader AS team_leader_15, t0.role AS role_16, t0.access_key AS access_key_17, t0.language AS language_18, t0.color AS color_19, t0.sidebar AS sidebar_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.description AS description_23, t0.job_title AS job_title_24, t0.reset_token AS reset_token_25, t0.id_office AS id_office_26, t0.id_company AS id_company_27, t0.id_user_rol AS id_user_rol_28, t0.id_team AS id_team_29 FROM users t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"admon@avexpress.tv"
]
|
| 3 | 0.31 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 | 37.80 ms |
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.client AS client_2, a0_.priority AS priority_3, a0_.supplier AS supplier_4, a0_.status AS status_5, a0_.daysBlock AS daysBlock_6, a0_.advancePayment AS advancePayment_7, a0_.idProposal AS idProposal_8, a0_.cateringName AS cateringName_9, a0_.boolCatering AS boolCatering_10, a0_.dateStart AS dateStart_11, a0_.dateEnd AS dateEnd_12, a0_.pax AS pax_13, a0_.deposit AS deposit_14, a0_.access_key AS access_key_15, a0_.description AS description_16, a0_.destinoId AS destinoId_17, a0_.createdAt AS createdAt_18, a0_.createdId AS createdId_19, a0_.updatedAt AS updatedAt_20, a0_.updatedId AS updatedId_21, a0_.comments AS comments_22, a0_.comments_in_inv AS comments_in_inv_23, a0_.comments_in_pro AS comments_in_pro_24, a0_.xtra_field_one AS xtra_field_one_25, a0_.xtra_field_two AS xtra_field_two_26, a0_.reservation_id AS reservation_id_27 FROM ave_files a0_ WHERE (a0_.dateStart <= ? AND COALESCE(a0_.dateEnd, a0_.dateStart) >= ?) AND a0_.status <> ? ORDER BY a0_.dateStart ASC
Parameters:
[ "2026-10-31 23:59:59" "2026-10-31 00:00:00" "Deleted" ] |
| 5 | 28.00 ms |
SELECT r0_.id AS id_0, r0_.title AS title_1, r0_.clientContact AS clientContact_2, r0_.contactUnregistered AS contactUnregistered_3, r0_.nameContactUnregistered AS nameContactUnregistered_4, r0_.phoneContactUnregistered AS phoneContactUnregistered_5, r0_.days AS days_6, r0_.createdAt AS createdAt_7, r0_.priority AS priority_8, r0_.createdBy AS createdBy_9, r0_.supplier AS supplier_10, r0_.status AS status_11, r0_.updatedAt AS updatedAt_12, r0_.updatedBy AS updatedBy_13, r0_.daysBlock AS daysBlock_14, r0_.dateStart AS dateStart_15, r0_.dateEnd AS dateEnd_16, r0_.pax AS pax_17, r0_.access_key AS access_key_18, r0_.description AS description_19, r0_.contract AS contract_20, r0_.token AS token_21, r0_.comAvGp AS comAvGp_22, r0_.comHtGp AS comHtGp_23, r0_.sucoe AS sucoe_24, r0_.breakdown_packages AS breakdown_packages_25, r0_.show_package_price AS show_package_price_26, r0_.infoFormWeb AS infoFormWeb_27, r0_.mailToClient AS mailToClient_28, r0_.client_id AS client_id_29 FROM reservation r0_ WHERE r0_.createdBy = ? AND r0_.status = ? AND r0_.days IS NOT NULL AND r0_.days >= ? ORDER BY r0_.days ASC
Parameters:
[ "33" "Bloqueo" "2026-10-31 00:00:00" ] |
| 6 | 0.36 ms |
SELECT r0_.id AS id_0, r0_.dateAt AS dateAt_1, r0_.text AS text_2, r0_.agent_id AS agent_id_3, r0_.reservation_id AS reservation_id_4, r0_.viewed AS viewed_5, r0_.created_id AS created_id_6, r0_.created_at AS created_at_7, r0_.updated_id AS updated_id_8, r0_.updated_at AS updated_at_9 FROM reservation_tracing r0_ WHERE r0_.agent_id = ? AND r0_.dateAt <= ? AND r0_.viewed = ?
Parameters:
[ 33 "2026-11-01 23:59:59" "NO" ] |
| 7 | 0.69 ms |
SELECT u0_.id AS id_0, u0_.text AS text_1, u0_.link_url AS link_url_2, u0_.link_label AS link_label_3, u0_.category AS category_4, u0_.seen_at AS seen_at_5, u0_.created_at AS created_at_6, u0_.expires_at AS expires_at_7, u0_.related_type AS related_type_8, u0_.related_id AS related_id_9, u0_.user_id AS user_id_10 FROM user_notification u0_ WHERE u0_.user_id = ? AND u0_.seen_at IS NULL AND ((u0_.expires_at IS NULL OR u0_.expires_at > ?)) ORDER BY u0_.created_at DESC LIMIT 20
Parameters:
[ 33 "2026-10-31 17:57:23" ] |
| 8 | 0.25 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:
[
"av"
]
|
| 9 | 0.21 ms |
SELECT t0.id AS id_1, t0.team AS team_2 FROM settings_team t0 WHERE t0.id = ?
Parameters:
[
8
]
|
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\Configuration | No errors. |
| App\Entity\User | No errors. |
| App\Entity\SettingsOffice | No errors. |
| App\Entity\SettingsCompany | No errors. |
| App\Entity\SettingsRol | No errors. |
| App\Entity\SettingsTeam | No errors. |
| App\Entity\UserNotification | No errors. |
| App\Entity\ManteApp | No errors. |
| App\Entity\Space | No errors. |
| App\MDS\VenuesBundle\Entity\ReservationLoungeDetails | No errors. |
| App\MDS\AvexpressBundle\Entity\AveFiles | No errors. |
| App\MDS\VenuesBundle\Entity\Reservation | No errors. |
| App\Entity\Client | No errors. |
| App\MDS\VenuesBundle\Entity\ReservationTracing | No errors. |
| App\Entity\SettingsBranding | No errors. |