GET https://ecsandbox.microtecnologiasmoviles.mx/item/view/eyJjbGF2ZSI6IjY5NDE4MTI3MDcxMTEifQ

Query Metrics

9 Database Queries
9 Different statements
5.26 ms Query time
0 Invalid entities
18 Managed entities

Queries

Group similar statements

# Time Info
1 0.23 ms
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:
[
  "ecsandbox"
]
2 1.15 ms
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:
[
  "6941812707111"
]
3 1.17 ms
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:
[
  "2410FPCC5G"
]
4 0.42 ms
SELECT t0.id AS id_1, t0.color AS color_2 FROM color_producto t0 WHERE t0.id = ?
Parameters:
[
  24
]
5 0.41 ms
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:
[
  328
]
6 0.61 ms
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:
[
  328
]
7 0.39 ms
SELECT t0.id AS id_1, t0.alias AS alias_2 FROM alias_productos t0 WHERE t0.id = ?
Parameters:
[
  53
]
8 0.48 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2 FROM marca t0 WHERE t0.id = ?
Parameters:
[
  1
]
9 0.39 ms
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:
[
  328
]

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