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

Query Metrics

10 Database Queries
9 Different statements
14.37 ms Query time
0 Invalid entities
23 Managed entities

Grouped Statements

Show all queries

Time Count Info
8.42 ms
(58.59%)
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:
[
  202
]
1.15 ms
(8.02%)
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:
[
  202
]
1.08 ms
(7.52%)
2
SELECT t0.id AS id_1, t0.color AS color_2 FROM color_producto t0 WHERE t0.id = ?
Parameters:
[
  2
]
1.04 ms
(7.26%)
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:
[
  "XT2427-1"
]
0.79 ms
(5.47%)
1
SELECT t0.id AS id_1, t0.alias AS alias_2 FROM alias_productos t0 WHERE t0.id = ?
Parameters:
[
  25
]
0.73 ms
(5.11%)
1
SELECT t0.id AS id_1, t0.nombre AS nombre_2 FROM marca t0 WHERE t0.id = ?
Parameters:
[
  5
]
0.66 ms
(4.57%)
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:
[
  "840023267802"
]
0.26 ms
(1.82%)
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:
[
  202
]
0.23 ms
(1.63%)
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 6
App\Entity\Colaboradores 5
App\Entity\PrecioColaborador 5
App\Entity\ColorProducto 3
App\Entity\Marca 1
App\Entity\Categoria 1
App\Entity\ProveedorProductos 1
App\Entity\AliasProductos 1