https://www.saisimmo.gebanalysis.cloud/single_announce/1666

Query Metrics

5 Database Queries
5 Different statements
3.39 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

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.