Query Metrics
6
Database Queries
6
Different statements
0.87 ms
Query time
0
Invalid entities
15
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.16 ms |
SELECT t0.id AS id_1, t0.dia_semana AS dia_semana_2, t0.hora_apertura AS hora_apertura_3, t0.inicio_descanso AS inicio_descanso_4, t0.fin_descanso AS fin_descanso_5, t0.hora_cierre AS hora_cierre_6, t0.es_cerrado AS es_cerrado_7 FROM horario t0
Parameters:
[]
|
||||||||||||||||||||||||||
| 2 | 0.19 ms |
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.nombre AS nombre_4, u0_.foto AS foto_5, u0_.puntos AS puntos_6, u0_.telefono AS telefono_7, u0_.color_calendario AS color_calendario_8, u0_.biografia AS biografia_9, u0_.instagram AS instagram_10, u0_.especialidad AS especialidad_11, u0_.dni AS dni_12 FROM user u0_ WHERE (u0_.roles LIKE ? OR u0_.roles LIKE ?) AND u0_.roles NOT LIKE ?
Parameters:
[ "%"ROLE_STAFF"%" "%"ROLE_ADMIN"%" "%"ROLE_SUPER_ADMIN"%" ]
|
||||||||||||||||||||||||||
| 3 | 0.12 ms |
SELECT t0.id AS id_1, t0.telefono AS telefono_2, t0.alergias AS alergias_3, t0.observaciones AS observaciones_4, t0.ultimo_servicio AS ultimo_servicio_5, t0.fecha_cumple AS fecha_cumple_6, t0.puntos_fidelidad AS puntos_fidelidad_7, t0.premios_canjeados AS premios_canjeados_8, t0.document_id AS document_id_9, t0.direccion_fiscal AS direccion_fiscal_10, t0.codigo_postal AS codigo_postal_11, t0.user_id AS user_id_12 FROM customer_profile t0 WHERE t0.user_id = ?
Parameters:
[
8
]
|
||||||||||||||||||||||||||
| 4 | 0.18 ms |
SELECT r0_.id AS id_0, r0_.nombre_cliente AS nombre_cliente_1, r0_.telefonocliente AS telefonocliente_2, r0_.horario AS horario_3, r0_.estado AS estado_4, r0_.fecha_fin AS fecha_fin_5, r0_.recordatorio_enviado AS recordatorio_enviado_6, r0_.email_cliente AS email_cliente_7, r0_.servicio_id AS servicio_id_8, r0_.usuario_id AS usuario_id_9, r0_.cliente_id AS cliente_id_10, r0_.variacion_producto_id AS variacion_producto_id_11 FROM reserva r0_ WHERE r0_.horario >= ?
Parameters:
[
"2026-08-05 00:00:00"
]
|
||||||||||||||||||||||||||
| 5 | 0.10 ms |
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.descripcion AS descripcion_3 FROM festivo t0
Parameters:
[]
|
||||||||||||||||||||||||||
| 6 | 0.12 ms |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.nif AS nif_3, t0.direccion AS direccion_4, t0.cp_ciudad AS cp_ciudad_5, t0.telefono AS telefono_6, t0.comision_tpv AS comision_tpv_7, t0.whatsapp AS whatsapp_8, t0.hero_imagen_url AS hero_imagen_url_9, t0.frase_gancho AS frase_gancho_10, t0.logo_url AS logo_url_11, t0.instagram AS instagram_12, t0.facebook AS facebook_13, t0.email AS email_14, t0.google_maps_url AS google_maps_url_15, t0.hero_video_url AS hero_video_url_16, t0.descripcion_personal AS descripcion_personal_17, t0.certificado_nombre AS certificado_nombre_18, t0.certificado_password AS certificado_password_19, t0.verifactu_activo AS verifactu_activo_20, t0.modo_pruebas AS modo_pruebas_21, t0.email_notificaciones AS email_notificaciones_22, t0.verifacti_api_key AS verifacti_api_key_23, t0.proximo_numero_f1 AS proximo_numero_f1_24, t0.proximo_numero_f2 AS proximo_numero_f2_25, t0.proximo_numero_rectificativa AS proximo_numero_rectificativa_26, t0.regimen_fiscal AS regimen_fiscal_27, t0.iban AS iban_28, t0.nombre_banco AS nombre_banco_29, t0.tipo_negocio AS tipo_negocio_30, t0.jurisdiccion_id AS jurisdiccion_id_31 FROM negocio t0
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Horario | 7 |
| App\Entity\Reserva | 2 |
| App\Entity\Servicio | 2 |
| App\Entity\User | 1 |
| App\Entity\Festivo | 1 |
| App\Entity\Negocio | 1 |
| App\Entity\Jurisdiccion | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Horario | No errors. |
| App\Entity\User | No errors. |
| App\Entity\CustomerProfile | No errors. |
| App\Entity\Reserva | No errors. |
| App\Entity\Servicio | No errors. |
| App\Entity\VariacionProducto | No errors. |
| App\Entity\Festivo | No errors. |
| App\Entity\Negocio | No errors. |
| App\Entity\Jurisdiccion | No errors. |