Query Metrics
10
Database Queries
9
Different statements
1.73 ms
Query time
1
Invalid entities
50
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
0.43 ms (24.55%) |
2 |
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:
[] |
||||||||||||||||||||||||||
|
0.21 ms (11.89%) |
1 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.es_tienda AS es_tienda_3, t0.nombre_eu AS nombre_eu_4, t0.imagen AS imagen_5 FROM catalogo_producto t0 WHERE t0.es_tienda = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||
|
0.20 ms (11.72%) |
1 |
SELECT t0.id AS id_1, t0.nombre_cliente AS nombre_cliente_2, t0.fecha_reserva AS fecha_reserva_3, t0.numero_personas AS numero_personas_4, t0.estado AS estado_5, t0.telefono_contacto AS telefono_contacto_6, t0.token AS token_7, t0.email_cliente AS email_cliente_8, t0.mesa_id AS mesa_id_9, t0.usuario_id AS usuario_id_10 FROM reserva_mesa t0
Parameters:
[]
|
||||||||||||||||||||||||||
|
0.20 ms (11.66%) |
1 |
SELECT t0.id AS id_1, t0.titulo AS titulo_2, t0.contenido AS contenido_3, t0.imagen AS imagen_4, t0.fecha_creacion AS fecha_creacion_5, t0.slug AS slug_6, t0.titulo_eu AS titulo_eu_7, t0.contenido_eu AS contenido_eu_8 FROM post t0 ORDER BY t0.fecha_creacion DESC LIMIT 3
Parameters:
[]
|
||||||||||||||||||||||||||
|
0.19 ms (10.86%) |
1 |
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 ?
Parameters:
[ "%"ROLE_ADMIN"%" "%"ROLE_STAFF"%" ]
|
||||||||||||||||||||||||||
|
0.17 ms (9.58%) |
1 |
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.precio AS precio_3, t0.stock AS stock_4, t0.codigo_barras AS codigo_barras_5, t0.imagen AS imagen_6, t0.activo AS activo_7, t0.marcado_para_pedido AS marcado_para_pedido_8, t0.cantidad_apedir AS cantidad_apedir_9, t0.precio_compra AS precio_compra_10, t0.iva_porcentaje AS iva_porcentaje_11, t0.nombre_eu AS nombre_eu_12, t0.descripcion_eu AS descripcion_eu_13, t0.indicaciones AS indicaciones_14, t0.indicaciones_eu AS indicaciones_eu_15, t0.tipopaquete AS tipopaquete_16, t0.atributo1 AS atributo1_17, t0.atributo2 AS atributo2_18, t0.producto_id AS producto_id_19 FROM variacion_producto t0
Parameters:
[]
|
||||||||||||||||||||||||||
|
0.13 ms (7.45%) |
1 |
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
]
|
||||||||||||||||||||||||||
|
0.11 ms (6.64%) |
1 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.precio AS precio_4, t0.precio_compra AS precio_compra_5, t0.stock AS stock_6, t0.codigo_barras AS codigo_barras_7, t0.imagen AS imagen_8, t0.activo AS activo_9, t0.stock_minimo AS stock_minimo_10, t0.marcado_para_pedido AS marcado_para_pedido_11, t0.indicaciones AS indicaciones_12, t0.tipo AS tipo_13, t0.iva_porcentaje AS iva_porcentaje_14, t0.cantidad_apedir AS cantidad_apedir_15, t0.nombre_eu AS nombre_eu_16, t0.descripcion_eu AS descripcion_eu_17, t0.indicaciones_eu AS indicaciones_eu_18 FROM producto t0 ORDER BY t0.id DESC LIMIT 4
Parameters:
[]
|
||||||||||||||||||||||||||
|
0.10 ms (5.66%) |
1 |
SELECT t0.id AS id_1, t0.clave AS clave_2, t0.valor AS valor_3, t0.valor_largo AS valor_largo_4 FROM ajustes 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\ReservaMesa | 13 |
| App\Entity\Ajustes | 11 |
| App\Entity\VariacionProducto | 9 |
| App\Entity\Mesa | 4 |
| App\Entity\CatalogoProducto | 4 |
| App\Entity\Producto | 4 |
| App\Entity\User | 2 |
| App\Entity\Post | 1 |
| App\Entity\Negocio | 1 |
| App\Entity\Jurisdiccion | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Ajustes | No errors. |
| App\Entity\Post | No errors. |
| App\Entity\Comentario | No errors. |
| App\Entity\ReservaMesa | No errors. |
| App\Entity\Mesa | No errors. |
| App\Entity\User | No errors. |
| App\Entity\CatalogoProducto | No errors. |
| App\Entity\VariacionProducto | No errors. |
| App\Entity\Producto |
|
| App\Entity\MovimientoStock | No errors. |
| App\Entity\CustomerProfile | No errors. |
| App\Entity\Reserva | No errors. |
| App\Entity\Negocio | No errors. |
| App\Entity\Jurisdiccion | No errors. |