GET https://abibsandbox.microtecnologiasmoviles.mx/item/view/eyJjbGF2ZSI6Ijg0MDAyMzI2ODgwOSJ9

Query Metrics

12 Database Queries
9 Different statements
10.74 ms Query time
0 Invalid entities
28 Managed entities

Grouped Statements

Show all queries

Time Count Info
3.76 ms
(34.99%)
1
SELECT t0.id AS id_1, t0.precio_venta AS precio_venta_2, t0.colaborador_id AS colaborador_id_3, t0.producto_id AS producto_id_4 FROM precio_colaborador t0 WHERE t0.producto_id = ?
Parameters:
[
  165
]
1.88 ms
(17.52%)
1
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.precio AS precio_3, t0.clave_producto AS clave_producto_4, t0.promocion AS promocion_5, t0.credicel AS credicel_6, t0.sku AS sku_7, t0.precio_compra AS precio_compra_8, t0.description AS description_9, t0.unidad_medida AS unidad_medida_10, t0.images AS images_11, t0.especificaciones AS especificaciones_12, t0.capacidad AS capacidad_13, t0.stock AS stock_14, t0.precio_credito AS precio_credito_15, t0.creation_date AS creation_date_16, t0.updated_date AS updated_date_17, t0.precio_mayoreo AS precio_mayoreo_18, t0.prioridad AS prioridad_19, t0.marca_id AS marca_id_20, t0.categoria_id AS categoria_id_21, t0.proveedor_id AS proveedor_id_22, t0.alias_id AS alias_id_23, t0.color_id AS color_id_24, t0.operador_movil_id AS operador_movil_id_25 FROM producto t0 WHERE t0.clave_producto = ? LIMIT 1
Parameters:
[
  "840023268809"
]
1.44 ms
(13.39%)
1
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.precio AS precio_3, t0.clave_producto AS clave_producto_4, t0.promocion AS promocion_5, t0.credicel AS credicel_6, t0.sku AS sku_7, t0.precio_compra AS precio_compra_8, t0.description AS description_9, t0.unidad_medida AS unidad_medida_10, t0.images AS images_11, t0.especificaciones AS especificaciones_12, t0.capacidad AS capacidad_13, t0.stock AS stock_14, t0.precio_credito AS precio_credito_15, t0.creation_date AS creation_date_16, t0.updated_date AS updated_date_17, t0.precio_mayoreo AS precio_mayoreo_18, t0.prioridad AS prioridad_19, t0.marca_id AS marca_id_20, t0.categoria_id AS categoria_id_21, t0.proveedor_id AS proveedor_id_22, t0.alias_id AS alias_id_23, t0.color_id AS color_id_24, t0.operador_movil_id AS operador_movil_id_25 FROM producto t0 WHERE t0.nombre = ?
Parameters:
[
  "XT2421-7"
]
1.14 ms
(10.58%)
4
SELECT t0.id AS id_1, t0.color AS color_2 FROM color_producto t0 WHERE t0.id = ?
Parameters:
[
  24
]
0.76 ms
(7.04%)
1
SELECT t0.id AS id_1, t0.nombre AS nombre_2 FROM marca t0 WHERE t0.id = ?
Parameters:
[
  5
]
0.67 ms
(6.21%)
1
SELECT t0.id AS id_1, t0.text AS text_2, t0.created_date AS created_date_3, t0.images AS images_4, t0.usuario_id AS usuario_id_5, t0.producto_id AS producto_id_6 FROM resenia t0 WHERE t0.producto_id = ?
Parameters:
[
  165
]
0.52 ms
(4.88%)
1
SELECT t0.id AS id_1, t0.alias AS alias_2 FROM alias_productos t0 WHERE t0.id = ?
Parameters:
[
  100
]
0.30 ms
(2.81%)
1
SELECT t0.id AS id_1, t0.text AS text_2, t0.created_date AS created_date_3, t0.usuario_id AS usuario_id_4, t0.producto_id AS producto_id_5 FROM preguntas t0 WHERE t0.producto_id = ?
Parameters:
[
  165
]
0.28 ms
(2.59%)
1
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.path_brandeo AS path_brandeo_3, t0.domain AS domain_4, t0.shop_name AS shop_name_5, t0.admin_shop AS admin_shop_6, t0.precios_credishop AS precios_credishop_7, t0.cambaceo AS cambaceo_8 FROM colaboradores t0 WHERE t0.domain = ? LIMIT 1
Parameters:
[
  "abibsandbox"
]

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\Producto 10
App\Entity\Colaboradores 5
App\Entity\PrecioColaborador 5
App\Entity\ColorProducto 4
App\Entity\Marca 1
App\Entity\Categoria 1
App\Entity\ProveedorProductos 1
App\Entity\AliasProductos 1