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

Query Metrics

7 Database Queries
6 Different statements
19.51 ms Query time
6 Invalid entities

Grouped Statements

Show all queries

Time Count Info
6.23 ms
(31.93%)
1
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, c0_.variante_producto_id AS variante_producto_id_7 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 WHERE c0_.productos_id = ? AND g2_.id = ?
Parameters:
[
  99
  5
]
5.60 ms
(28.71%)
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.requiere_documento_adjunto AS requiere_documento_adjunto_11, t0.suscripcion_disponible AS suscripcion_disponible_12, t0.marca_id AS marca_id_13, t0.categoriaproducto_id AS categoriaproducto_id_14, t0.tipoproducto_id AS tipoproducto_id_15 FROM productos t0 WHERE t0.id = ?
Parameters:
[
  "99"
]
3.50 ms
(17.96%)
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.56 ms
(7.98%)
2
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.diurno AS diurno_4, t0.nocturno AS nocturno_5, t0.ordinario AS ordinario_6, t0.festivo AS festivo_7, t0.tipoproducto_id AS tipoproducto_id_8 FROM subtipoproducto t0 WHERE t0.id = ?
Parameters:
[
  55
]
1.33 ms
(6.83%)
1
SELECT t0.id AS id_1, t0.nombre AS nombre_2 FROM grupo_listas_precios t0 WHERE t0.id = ?
Parameters:
[
  5
]
1.28 ms
(6.59%)
1
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\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\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\SuscripcionPeriodo 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.