Query Metrics
4
Database Queries
4
Different statements
4.26 ms
Query time
1
Invalid entities
17
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.21 ms |
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 WHERE t0.tipo = ? AND t0.activo = ?
Parameters:
[ "libro" 1 ]
|
||||||||||||||||||||||||
| 2 | 0.24 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nombre AS nombre_5, t0.foto AS foto_6, t0.puntos AS puntos_7, t0.telefono AS telefono_8, t0.color_calendario AS color_calendario_9, t0.biografia AS biografia_10, t0.instagram AS instagram_11, t0.especialidad AS especialidad_12, t0.dni AS dni_13, t14.id AS id_15, t14.telefono AS telefono_16, t14.alergias AS alergias_17, t14.observaciones AS observaciones_18, t14.ultimo_servicio AS ultimo_servicio_19, t14.fecha_cumple AS fecha_cumple_20, t14.puntos_fidelidad AS puntos_fidelidad_21, t14.premios_canjeados AS premios_canjeados_22, t14.document_id AS document_id_23, t14.direccion_fiscal AS direccion_fiscal_24, t14.codigo_postal AS codigo_postal_25, t14.user_id AS user_id_26 FROM user t0 LEFT JOIN customer_profile t14 ON t14.user_id = t0.id
Parameters:
[]
|
||||||||||||||||||||||||
| 3 | 3.42 ms |
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.id DESC LIMIT 3
Parameters:
[]
|
||||||||||||||||||||||||
| 4 | 0.39 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\User | 8 |
| App\Entity\CustomerProfile | 4 |
| App\Entity\Producto | 2 |
| App\Entity\Post | 1 |
| App\Entity\Negocio | 1 |
| App\Entity\Jurisdiccion | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Producto |
|
| App\Entity\MovimientoStock | No errors. |
| App\Entity\User | No errors. |
| App\Entity\CustomerProfile | No errors. |
| App\Entity\Reserva | No errors. |
| App\Entity\Post | No errors. |
| App\Entity\Comentario | No errors. |
| App\Entity\Negocio | No errors. |
| App\Entity\Jurisdiccion | No errors. |