Query Metrics
3
Database Queries
3
Different statements
39.26 ms
Query time
0
Invalid entities
1
Managed entities
Queries
#▲ | Time | Info | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 0.40 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 | 26.97 ms |
SELECT p0_.id AS id_0, p0_.nombre AS nombre_1, p0_.precio AS precio_2, p0_.clave_producto AS clave_producto_3, p0_.promocion AS promocion_4, p0_.credicel AS credicel_5, p0_.sku AS sku_6, p0_.precio_compra AS precio_compra_7, p0_.description AS description_8, p0_.unidad_medida AS unidad_medida_9, p0_.images AS images_10, p0_.especificaciones AS especificaciones_11, p0_.capacidad AS capacidad_12, p0_.stock AS stock_13, p0_.precio_credito AS precio_credito_14, p0_.creation_date AS creation_date_15, p0_.updated_date AS updated_date_16, p0_.precio_mayoreo AS precio_mayoreo_17, p0_.prioridad AS prioridad_18, c1_.id AS id_19, c1_.color AS color_20, a2_.id AS id_21, a2_.alias AS alias_22, m3_.id AS id_23, m3_.nombre AS nombre_24, p4_.id AS id_25, p4_.precio_venta AS precio_venta_26, c5_.id AS id_27, c5_.nombre AS nombre_28, c5_.path_brandeo AS path_brandeo_29, c5_.domain AS domain_30, c5_.shop_name AS shop_name_31, c5_.admin_shop AS admin_shop_32, c5_.precios_credishop AS precios_credishop_33, c5_.cambaceo AS cambaceo_34 FROM producto p0_ LEFT JOIN color_producto c1_ ON p0_.color_id = c1_.id LEFT JOIN alias_productos a2_ ON p0_.alias_id = a2_.id LEFT JOIN marca m3_ ON p0_.marca_id = m3_.id LEFT JOIN precio_colaborador p4_ ON p0_.id = p4_.producto_id LEFT JOIN colaboradores c5_ ON p4_.colaborador_id = c5_.id WHERE p0_.images IS NOT NULL AND p0_.credicel IS NOT NULL AND p0_.stock > ? AND p4_.colaborador_id = ? AND ((p4_.precio_venta > 0 AND p4_.precio_venta IS NOT NULL)) ORDER BY p0_.id DESC
Parameters:
[ 5 1 ]
|
||||||||||||||||||||||||||||||
3 | 11.89 ms |
SELECT p0_.id AS id_0, p0_.nombre AS nombre_1, p0_.precio AS precio_2, p0_.clave_producto AS clave_producto_3, p0_.promocion AS promocion_4, p0_.credicel AS credicel_5, p0_.sku AS sku_6, p0_.precio_compra AS precio_compra_7, p0_.description AS description_8, p0_.unidad_medida AS unidad_medida_9, p0_.images AS images_10, p0_.especificaciones AS especificaciones_11, p0_.capacidad AS capacidad_12, p0_.stock AS stock_13, p0_.precio_credito AS precio_credito_14, p0_.creation_date AS creation_date_15, p0_.updated_date AS updated_date_16, p0_.precio_mayoreo AS precio_mayoreo_17, p0_.prioridad AS prioridad_18, c1_.id AS id_19, c1_.color AS color_20, a2_.id AS id_21, a2_.alias AS alias_22, m3_.id AS id_23, m3_.nombre AS nombre_24, p4_.id AS id_25, p4_.precio_venta AS precio_venta_26, c5_.id AS id_27, c5_.nombre AS nombre_28, c5_.path_brandeo AS path_brandeo_29, c5_.domain AS domain_30, c5_.shop_name AS shop_name_31, c5_.admin_shop AS admin_shop_32, c5_.precios_credishop AS precios_credishop_33, c5_.cambaceo AS cambaceo_34 FROM producto p0_ LEFT JOIN color_producto c1_ ON p0_.color_id = c1_.id LEFT JOIN alias_productos a2_ ON p0_.alias_id = a2_.id LEFT JOIN marca m3_ ON p0_.marca_id = m3_.id LEFT JOIN precio_colaborador p4_ ON p0_.id = p4_.producto_id LEFT JOIN colaboradores c5_ ON p4_.colaborador_id = c5_.id WHERE p0_.images IS NOT NULL AND p0_.credicel IS NULL AND p0_.stock > ? AND p4_.colaborador_id = ? AND ((p4_.precio_venta > 0 AND p4_.precio_venta IS NOT NULL)) ORDER BY p0_.id DESC
Parameters:
[ 5 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.
Managed Entities
default entity manager
Class | Amount of managed objects |
---|---|
App\Entity\Colaboradores | 1 |
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\Colaboradores | No errors. |
App\Entity\PrecioColaborador | No errors. |
App\Entity\OperadorMovil | No errors. |
App\Entity\Orden | No errors. |
App\Entity\User | No errors. |
App\Entity\Producto | No errors. |
App\Entity\ColorProducto | No errors. |
App\Entity\AliasProductos | No errors. |
App\Entity\Marca | No errors. |