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

Query Metrics

9 Database Queries
9 Different statements
50.80 ms Query time
0 Invalid entities
16 Managed entities

Queries

Group similar statements

# Time Info
1 0.55 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.35 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:
[
  "840023282720"
]
3 1.45 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:
[
  "XT2421.-7"
]
4 0.26 ms
SELECT t0.id AS id_1, t0.color AS color_2 FROM color_producto t0 WHERE t0.id = ?
Parameters:
[
  16
]
5 0.40 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:
[
  469
]
6 1.27 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:
[
  469
]
7 13.71 ms
SELECT t0.id AS id_1, t0.alias AS alias_2 FROM alias_productos t0 WHERE t0.id = ?
Parameters:
[
  100
]
8 9.93 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2 FROM marca t0 WHERE t0.id = ?
Parameters:
[
  5
]
9 21.87 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:
[
  469
]

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 1
App\Entity\Marca 1
App\Entity\Categoria 1
App\Entity\ProveedorProductos 1
App\Entity\AliasProductos 1
App\Entity\ColorProducto 1