Query Metrics
5
Database Queries
5
Different statements
3.39 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.96 ms (57.94%) |
1 |
SELECT t0.id AS id_3, t0.name AS name_4, t0.image AS image_5, t0.price AS price_6, t0.description AS description_7, t0.old_price AS old_price_8, t0.quantity AS quantity_9, t0.product_type AS product_type_10, t0.meta_title AS meta_title_11, t0.meta_description AS meta_description_12, t0.meta_keywords AS meta_keywords_13, t0.slug AS slug_14, t0.created_at AS created_at_15, t0.is_price_reduced_per_percent AS is_price_reduced_per_percent_16, t0.percent_reduction AS percent_reduction_17, t0.sku_code AS sku_code_18, t0.short_description AS short_description_19, t0.is_published AS is_published_20, t0.sku_code_shop AS sku_code_shop_21, t0.end_at AS end_at_22, t0.is_deals AS is_deals_23, t0.weight AS weight_24, t0.promotion_id AS promotion_id_25, t0.vendor_id AS vendor_id_26, t0.brand_id AS brand_id_27, t0.parent_category_id AS parent_category_id_28, t0.customer_id AS customer_id_29, t0.dtype, t1.regular_price AS regular_price_30 FROM product t0 LEFT JOIN article t1 ON t0.id = t1.id LEFT JOIN shop_product t2 ON t0.id = t2.id WHERE t0.id = ?
Parameters:
[
"1666"
]
|
0.47 ms (14.00%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.parent_category_id AS parent_category_id_7 FROM flexy_categoryproduct t0 WHERE t0.for_product_type = ?
Parameters:
[
"announce"
]
|
0.43 ms (12.76%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.parent_category_id AS parent_category_id_7 FROM flexy_categoryproduct t0 INNER JOIN product_category_product ON t0.id = product_category_product.category_product_id WHERE product_category_product.product_id = ?
Parameters:
[
1666
]
|
0.31 ms (9.10%) |
1 |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.comment AS comment_3, t0.rating AS rating_4, t0.customer_id AS customer_id_5, t0.product_id AS product_id_6 FROM comment t0 WHERE t0.product_id = ?
Parameters:
[
1666
]
|
0.21 ms (6.20%) |
1 |
SELECT t0.id AS id_1, t0.path AS path_2, t0.alt AS alt_3, t0.updated_at AS updated_at_4, t0.product_id AS product_id_5 FROM image_product t0 WHERE t0.product_id = ?
Parameters:
[
1666
]
|
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.
Entities Mapping
Class | Mapping errors |
---|---|
App\Flexy\ShopBundle\Entity\Product\Product | No errors. |
App\Flexy\StockBundle\Entity\Article | No errors. |
App\Flexy\ShopBundle\Entity\Product\ProductShop | No errors. |
App\Flexy\ShopBundle\Entity\Promotion\Promotion | No errors. |
App\Flexy\ShopBundle\Entity\Vendor\Vendor | No errors. |
App\Flexy\ShopBundle\Entity\Brand | No errors. |
App\Flexy\ShopBundle\Entity\Product\CategoryProduct | No errors. |
App\Flexy\ShopBundle\Entity\Customer\Customer | No errors. |
App\Flexy\ShopBundle\Entity\Product\AttributValue | No errors. |
App\Flexy\ShopBundle\Entity\Product\ImageProduct | No errors. |
App\Flexy\ShopBundle\Entity\Product\ProductVariant | No errors. |
App\Flexy\ShopBundle\Entity\Order\OrderItem | No errors. |
App\Flexy\ShopBundle\Entity\Product\Comment | No errors. |
App\Flexy\ShopBundle\Entity\Product\Attribut | No errors. |