GET https://dev.quiro.care/productos/cart/99

Query Metrics

6 Database Queries
6 Different statements
4.88 ms Query time
6 Invalid entities

Queries

Group similar statements

# Time Info
1 0.48 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"
]
2 1.21 ms
SELECT c0_.id AS id_0, c0_.clave AS clave_1, c0_.valor AS valor_2, c0_.descripcion AS descripcion_3, c0_.fecha_creacion AS fecha_creacion_4, c0_.fecha_modificacion AS fecha_modificacion_5, c0_.grupo_listas_precios_id AS grupo_listas_precios_id_6 FROM configuracion_general c0_ WHERE c0_.clave = ?
Parameters:
[
  "grupo_lista_precios_productos"
]
3 0.68 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2 FROM grupo_listas_precios t0 WHERE t0.id = ?
Parameters:
[
  5
]
4 1.11 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.is_active AS is_active_4 FROM catalogoprecio t0 INNER JOIN grupo_listas_precios_catalogoprecio ON t0.id = grupo_listas_precios_catalogoprecio.catalogoprecio_id WHERE grupo_listas_precios_catalogoprecio.grupo_listas_precios_id = ?
Parameters:
[
  5
]
5 1.12 ms
SELECT t0.id AS id_1, t0.precio AS precio_2, t0.codigointegracion AS codigointegracion_3, t0.catalogoprecio_id AS catalogoprecio_id_4, t0.productos_id AS productos_id_5, t0.paqueteproducto_id AS paqueteproducto_id_6, t0.condicionesvariante_id AS condicionesvariante_id_7 FROM catalogoprecio_producto t0 WHERE t0.catalogoprecio_id = ? AND t0.productos_id = ? LIMIT 1
Parameters:
[
  18
  99
]
6 0.26 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
]

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\Productos No errors.
App\Entity\Marcaproducto No errors.
App\Entity\Categoriaproducto No errors.
App\Entity\Tipoproducto No errors.
App\Entity\Subtipoproducto No errors.
App\Entity\Paqueteproducto 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\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\ConfiguracionGeneral No errors.
App\Entity\GrupoListasPrecios No errors.
App\Entity\Catalogoprecio No errors.
App\Entity\Persona
  • The mappings App\Entity\Persona#posicionfiscal and App\Entity\Tiporesponsabilidad#personas are inconsistent with each other.
  • If association App\Entity\Persona#posicionfiscal is many-to-one, then the inversed side App\Entity\Tiporesponsabilidad#personas has to be one-to-many.
App\Entity\ConfigPaqueteVar No errors.
App\Entity\BloqueoSistema No errors.
App\Entity\User No errors.