GET https://dev.quiro.care/catalogo/

Response
200 OK
IP
216.73.216.150
Profiled on
Token
b92dae

Query Metrics

21 Database Queries
8 Different statements
8.67 ms Query time
5 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.45 ms 
SELECT t0.id AS id_1, t0.clave AS clave_2, t0.valor AS valor_3, t0.descripcion AS descripcion_4, t0.fecha_creacion AS fecha_creacion_5, t0.fecha_modificacion AS fecha_modificacion_6, t0.grupo_listas_precios_id AS grupo_listas_precios_id_7 FROM configuracion_general t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
2 0.89 ms 
SELECT COUNT(c0_.id) AS sclr_0 FROM catalogoprecio_producto c0_ INNER JOIN catalogoprecio c1_ ON c0_.catalogoprecio_id = c1_.id INNER JOIN grupo_listas_precios_catalogoprecio g3_ ON c1_.id = g3_.catalogoprecio_id INNER JOIN grupo_listas_precios g2_ ON g2_.id = g3_.grupo_listas_precios_id INNER JOIN productos p4_ ON c0_.productos_id = p4_.id WHERE g2_.id = ? AND p4_.visible = 1 AND p4_.is_active = 1 AND c0_.productos_id IS NOT NULL
Parameters: 
[
  5
]
View formatted query    View runnable query    Explain query
3 0.56 ms 
SELECT c0_.id AS id_0, c0_.precio AS precio_1, c0_.codigointegracion AS codigointegracion_2, c0_.catalogoprecio_id AS catalogoprecio_id_3, c0_.productos_id AS productos_id_4, c0_.paqueteproducto_id AS paqueteproducto_id_5, c0_.condicionesvariante_id AS condicionesvariante_id_6 FROM catalogoprecio_producto c0_ INNER JOIN catalogoprecio c1_ ON c0_.catalogoprecio_id = c1_.id INNER JOIN grupo_listas_precios_catalogoprecio g3_ ON c1_.id = g3_.catalogoprecio_id INNER JOIN grupo_listas_precios g2_ ON g2_.id = g3_.grupo_listas_precios_id INNER JOIN productos p4_ ON c0_.productos_id = p4_.id WHERE g2_.id = ? AND p4_.visible = 1 AND p4_.is_active = 1 AND c0_.productos_id IS NOT NULL
Parameters: 
[
  5
]
View formatted query    View runnable query    Explain query
4 0.40 ms 
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.is_active AS is_active_4, t0.costo AS costo_5, t0.urlimagen AS urlimagen_6, t0.urlvideo AS urlvideo_7, t0.visible AS visible_8, t0.carrounico AS carrounico_9, t0.requiere_agenda AS requiere_agenda_10, t0.marca_id AS marca_id_11, t0.categoriaproducto_id AS categoriaproducto_id_12, t0.tipoproducto_id AS tipoproducto_id_13, t0.subtipoproducto_id AS subtipoproducto_id_14 FROM productos t0 WHERE t0.id = ?
Parameters: 
[
  90
]
View formatted query    View runnable query    Explain query
5 0.45 ms 
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.is_active AS is_active_4, t0.costo AS costo_5, t0.urlimagen AS urlimagen_6, t0.urlvideo AS urlvideo_7, t0.visible AS visible_8, t0.carrounico AS carrounico_9, t0.requiere_agenda AS requiere_agenda_10, t0.marca_id AS marca_id_11, t0.categoriaproducto_id AS categoriaproducto_id_12, t0.tipoproducto_id AS tipoproducto_id_13, t0.subtipoproducto_id AS subtipoproducto_id_14 FROM productos t0 WHERE t0.id = ?
Parameters: 
[
  91
]
View formatted query    View runnable query    Explain query
6 0.34 ms 
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.is_active AS is_active_4, t0.costo AS costo_5, t0.urlimagen AS urlimagen_6, t0.urlvideo AS urlvideo_7, t0.visible AS visible_8, t0.carrounico AS carrounico_9, t0.requiere_agenda AS requiere_agenda_10, t0.marca_id AS marca_id_11, t0.categoriaproducto_id AS categoriaproducto_id_12, t0.tipoproducto_id AS tipoproducto_id_13, t0.subtipoproducto_id AS subtipoproducto_id_14 FROM productos t0 WHERE t0.id = ?
Parameters: 
[
  93
]
View formatted query    View runnable query    Explain query
7 0.36 ms 
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.is_active AS is_active_4, t0.costo AS costo_5, t0.urlimagen AS urlimagen_6, t0.urlvideo AS urlvideo_7, t0.visible AS visible_8, t0.carrounico AS carrounico_9, t0.requiere_agenda AS requiere_agenda_10, t0.marca_id AS marca_id_11, t0.categoriaproducto_id AS categoriaproducto_id_12, t0.tipoproducto_id AS tipoproducto_id_13, t0.subtipoproducto_id AS subtipoproducto_id_14 FROM productos t0 WHERE t0.id = ?
Parameters: 
[
  94
]
View formatted query    View runnable query    Explain query
8 0.33 ms 
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.is_active AS is_active_4, t0.costo AS costo_5, t0.urlimagen AS urlimagen_6, t0.urlvideo AS urlvideo_7, t0.visible AS visible_8, t0.carrounico AS carrounico_9, t0.requiere_agenda AS requiere_agenda_10, t0.marca_id AS marca_id_11, t0.categoriaproducto_id AS categoriaproducto_id_12, t0.tipoproducto_id AS tipoproducto_id_13, t0.subtipoproducto_id AS subtipoproducto_id_14 FROM productos t0 WHERE t0.id = ?
Parameters: 
[
  95
]
View formatted query    View runnable query    Explain query
9 0.44 ms 
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.is_active AS is_active_4, t0.costo AS costo_5, t0.urlimagen AS urlimagen_6, t0.urlvideo AS urlvideo_7, t0.visible AS visible_8, t0.carrounico AS carrounico_9, t0.requiere_agenda AS requiere_agenda_10, t0.marca_id AS marca_id_11, t0.categoriaproducto_id AS categoriaproducto_id_12, t0.tipoproducto_id AS tipoproducto_id_13, t0.subtipoproducto_id AS subtipoproducto_id_14 FROM productos t0 WHERE t0.id = ?
Parameters: 
[
  97
]
View formatted query    View runnable query    Explain query
10 0.57 ms 
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.is_active AS is_active_4, t0.costo AS costo_5, t0.urlimagen AS urlimagen_6, t0.urlvideo AS urlvideo_7, t0.visible AS visible_8, t0.carrounico AS carrounico_9, t0.requiere_agenda AS requiere_agenda_10, t0.marca_id AS marca_id_11, t0.categoriaproducto_id AS categoriaproducto_id_12, t0.tipoproducto_id AS tipoproducto_id_13, t0.subtipoproducto_id AS subtipoproducto_id_14 FROM productos t0 WHERE t0.id = ?
Parameters: 
[
  98
]
View formatted query    View runnable query    Explain query
11 0.34 ms 
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.is_active AS is_active_4, t0.costo AS costo_5, t0.urlimagen AS urlimagen_6, t0.urlvideo AS urlvideo_7, t0.visible AS visible_8, t0.carrounico AS carrounico_9, t0.requiere_agenda AS requiere_agenda_10, t0.marca_id AS marca_id_11, t0.categoriaproducto_id AS categoriaproducto_id_12, t0.tipoproducto_id AS tipoproducto_id_13, t0.subtipoproducto_id AS subtipoproducto_id_14 FROM productos t0 WHERE t0.id = ?
Parameters: 
[
  99
]
View formatted query    View runnable query    Explain query
12 0.38 ms 
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.is_active AS is_active_4, t0.costo AS costo_5, t0.urlimagen AS urlimagen_6, t0.urlvideo AS urlvideo_7, t0.visible AS visible_8, t0.carrounico AS carrounico_9, t0.requiere_agenda AS requiere_agenda_10, t0.marca_id AS marca_id_11, t0.categoriaproducto_id AS categoriaproducto_id_12, t0.tipoproducto_id AS tipoproducto_id_13, t0.subtipoproducto_id AS subtipoproducto_id_14 FROM productos t0 WHERE t0.id = ?
Parameters: 
[
  81
]
View formatted query    View runnable query    Explain query
13 0.28 ms 
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.is_active AS is_active_4, t0.costo AS costo_5, t0.urlimagen AS urlimagen_6, t0.urlvideo AS urlvideo_7, t0.visible AS visible_8, t0.carrounico AS carrounico_9, t0.requiere_agenda AS requiere_agenda_10, t0.marca_id AS marca_id_11, t0.categoriaproducto_id AS categoriaproducto_id_12, t0.tipoproducto_id AS tipoproducto_id_13, t0.subtipoproducto_id AS subtipoproducto_id_14 FROM productos t0 WHERE t0.id = ?
Parameters: 
[
  100
]
View formatted query    View runnable query    Explain query
14 0.34 ms 
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.is_active AS is_active_4, t0.costo AS costo_5, t0.urlimagen AS urlimagen_6, t0.urlvideo AS urlvideo_7, t0.visible AS visible_8, t0.carrounico AS carrounico_9, t0.requiere_agenda AS requiere_agenda_10, t0.marca_id AS marca_id_11, t0.categoriaproducto_id AS categoriaproducto_id_12, t0.tipoproducto_id AS tipoproducto_id_13, t0.subtipoproducto_id AS subtipoproducto_id_14 FROM productos t0 WHERE t0.id = ?
Parameters: 
[
  101
]
View formatted query    View runnable query    Explain query
15 0.31 ms 
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.is_active AS is_active_4, t0.costo AS costo_5, t0.urlimagen AS urlimagen_6, t0.urlvideo AS urlvideo_7, t0.visible AS visible_8, t0.carrounico AS carrounico_9, t0.requiere_agenda AS requiere_agenda_10, t0.marca_id AS marca_id_11, t0.categoriaproducto_id AS categoriaproducto_id_12, t0.tipoproducto_id AS tipoproducto_id_13, t0.subtipoproducto_id AS subtipoproducto_id_14 FROM productos t0 WHERE t0.id = ?
Parameters: 
[
  102
]
View formatted query    View runnable query    Explain query
16 0.33 ms 
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.is_active AS is_active_4, t0.costo AS costo_5, t0.urlimagen AS urlimagen_6, t0.urlvideo AS urlvideo_7, t0.visible AS visible_8, t0.carrounico AS carrounico_9, t0.requiere_agenda AS requiere_agenda_10, t0.marca_id AS marca_id_11, t0.categoriaproducto_id AS categoriaproducto_id_12, t0.tipoproducto_id AS tipoproducto_id_13, t0.subtipoproducto_id AS subtipoproducto_id_14 FROM productos t0 WHERE t0.id = ?
Parameters: 
[
  103
]
View formatted query    View runnable query    Explain query
17 0.31 ms 
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.is_active AS is_active_4, t0.costo AS costo_5, t0.urlimagen AS urlimagen_6, t0.urlvideo AS urlvideo_7, t0.visible AS visible_8, t0.carrounico AS carrounico_9, t0.requiere_agenda AS requiere_agenda_10, t0.marca_id AS marca_id_11, t0.categoriaproducto_id AS categoriaproducto_id_12, t0.tipoproducto_id AS tipoproducto_id_13, t0.subtipoproducto_id AS subtipoproducto_id_14 FROM productos t0 WHERE t0.id = ?
Parameters: 
[
  104
]
View formatted query    View runnable query    Explain query
18 0.51 ms 
SELECT COUNT(c0_.id) AS sclr_0 FROM catalogoprecio_producto c0_ INNER JOIN catalogoprecio c1_ ON c0_.catalogoprecio_id = c1_.id INNER JOIN grupo_listas_precios_catalogoprecio g3_ ON c1_.id = g3_.catalogoprecio_id INNER JOIN grupo_listas_precios g2_ ON g2_.id = g3_.grupo_listas_precios_id INNER JOIN paqueteproducto p4_ ON c0_.paqueteproducto_id = p4_.id WHERE g2_.id = ? AND p4_.visible = 1 AND p4_.is_active = 1 AND c0_.paqueteproducto_id IS NOT NULL
Parameters: 
[
  5
]
View formatted query    View runnable query    Explain query
19 0.44 ms 
SELECT c0_.id AS id_0, c0_.precio AS precio_1, c0_.codigointegracion AS codigointegracion_2, c0_.catalogoprecio_id AS catalogoprecio_id_3, c0_.productos_id AS productos_id_4, c0_.paqueteproducto_id AS paqueteproducto_id_5, c0_.condicionesvariante_id AS condicionesvariante_id_6 FROM catalogoprecio_producto c0_ INNER JOIN catalogoprecio c1_ ON c0_.catalogoprecio_id = c1_.id INNER JOIN grupo_listas_precios_catalogoprecio g3_ ON c1_.id = g3_.catalogoprecio_id INNER JOIN grupo_listas_precios g2_ ON g2_.id = g3_.grupo_listas_precios_id INNER JOIN paqueteproducto p4_ ON c0_.paqueteproducto_id = p4_.id WHERE g2_.id = ? AND p4_.visible = 1 AND p4_.is_active = 1 AND c0_.paqueteproducto_id IS NOT NULL
Parameters: 
[
  5
]
View formatted query    View runnable query    Explain query
20 0.29 ms 
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.is_active AS is_active_4, t0.costo AS costo_5, t0.urlimagen AS urlimagen_6, t0.urlvideo AS urlvideo_7, t0.visible AS visible_8, t0.requiere_agenda AS requiere_agenda_9, t0.categoriaproducto_id AS categoriaproducto_id_10, t0.tipoproducto_id AS tipoproducto_id_11, t0.subtipoproducto_id AS subtipoproducto_id_12 FROM paqueteproducto t0 WHERE t0.id = ?
Parameters: 
[
  31
]
View formatted query    View runnable query    Explain query
21 0.35 ms 
SELECT b0_.id AS id_0, b0_.activo AS activo_1, b0_.fecha_inicio AS fecha_inicio_2, b0_.fecha_fin AS fecha_fin_3, b0_.motivo AS motivo_4, b0_.mensaje_usuarios AS mensaje_usuarios_5, b0_.bloqueo_total AS bloqueo_total_6, b0_.modulos_bloqueados AS modulos_bloqueados_7, b0_.bloqueo_indefinido AS bloqueo_indefinido_8, b0_.fecha_creacion AS fecha_creacion_9, b0_.fecha_modificacion AS fecha_modificacion_10, b0_.fecha_activacion AS fecha_activacion_11, b0_.fecha_desactivacion AS fecha_desactivacion_12, b0_.creado_por_id AS creado_por_id_13, b0_.desactivado_por_id AS desactivado_por_id_14 FROM bloqueo_sistema b0_ WHERE b0_.activo = ? ORDER BY b0_.fecha_creacion DESC LIMIT 1
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query

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\ConfiguracionGeneral No errors.
App\Entity\GrupoListasPrecios No errors.
App\Entity\CatalogoprecioProducto
  • The association App\Entity\CatalogoprecioProducto#condicionesvariante refers to the inverse side field App\Entity\ConfigPaqueteVar#catalogoprecioProductos which does not exist.
App\Entity\Catalogoprecio No errors.
App\Entity\Productos No errors.
App\Entity\Paqueteproducto No errors.
App\Entity\ConfigPaqueteVar No errors.
App\Entity\Marcaproducto No errors.
App\Entity\Categoriaproducto No errors.
App\Entity\Tipoproducto No errors.
App\Entity\Subtipoproducto No errors.
App\Entity\Solicitudcobertura
  • The association App\Entity\Solicitudcobertura#usuariomodifica refers to the inverse side field App\Entity\User#solicitudusuariomodifica which does not exist.
App\Entity\TipoclienteProducto No errors.
App\Entity\Servicio
  • The mappings App\Entity\Servicio#personaresponsable and App\Entity\Persona#servicios are inconsistent with each other.
App\Entity\Pedido
  • The association App\Entity\Pedido#solicitudcobertura refers to the inverse side field App\Entity\Solicitudcobertura#pedidos which does not exist.
App\Entity\CitaProducto
  • The association App\Entity\CitaProducto#cliente refers to the inverse side field App\Entity\Persona#citaProductos which does not exist.
  • The association App\Entity\CitaProducto#pedido refers to the inverse side field App\Entity\Pedido#citaProductos which does not exist.
App\Entity\Especializaciones No errors.
App\Entity\BloqueoSistema No errors.
App\Entity\User No errors.