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

Query Metrics

5 Database Queries
5 Different statements
5.49 ms Query time
6 Invalid entities
6 Managed entities

Grouped Statements

Show all queries

Time Count Info
1.68 ms
(30.64%)
1
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"
]
1.37 ms
(24.93%)
1
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"
]
1.16 ms
(21.07%)
1
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
]
0.72 ms
(13.03%)
1
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
]
0.57 ms
(10.33%)
1
SELECT t0.id AS id_1, t0.nombre AS nombre_2 FROM grupo_listas_precios t0 WHERE t0.id = ?
Parameters:
[
  5
]

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\Productos 1
App\Entity\Categoriaproducto 1
App\Entity\Tipoproducto 1
App\Entity\GrupoListasPrecios 1
App\Entity\Catalogoprecio 1
App\Entity\CatalogoprecioProducto 1

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.
  • The association App\Entity\Pedido#acudiente refers to the inverse side field App\Entity\Persona#pedidosacudiente 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\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.