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

Query Metrics

3 Database Queries
3 Different statements
3.63 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.52 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.image AS image_2, p0_.price AS price_3, p0_.description AS description_4, p0_.old_price AS old_price_5, p0_.quantity AS quantity_6, p0_.product_type AS product_type_7, p0_.meta_title AS meta_title_8, p0_.meta_description AS meta_description_9, p0_.meta_keywords AS meta_keywords_10, p0_.slug AS slug_11, p0_.created_at AS created_at_12, p0_.is_price_reduced_per_percent AS is_price_reduced_per_percent_13, p0_.percent_reduction AS percent_reduction_14, p0_.sku_code AS sku_code_15, p0_.short_description AS short_description_16, p0_.is_published AS is_published_17, p0_.sku_code_shop AS sku_code_shop_18, p0_.end_at AS end_at_19, p0_.is_deals AS is_deals_20, p0_.weight AS weight_21, a1_.regular_price AS regular_price_22, p0_.dtype AS dtype_23, p0_.promotion_id AS promotion_id_24, p0_.vendor_id AS vendor_id_25, p0_.brand_id AS brand_id_26, p0_.parent_category_id AS parent_category_id_27, p0_.customer_id AS customer_id_28 FROM product p0_ LEFT JOIN article a1_ ON p0_.id = a1_.id LEFT JOIN shop_product s2_ ON p0_.id = s2_.id WHERE p0_.product_type = 'announce' AND p0_.is_published = 1
Parameters:
[]
2 0.99 ms
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"
]
3 1.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3 FROM brand t0
Parameters:
[]

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\ShopBundle\Entity\Product\CategoryProduct No errors.
App\Flexy\ShopBundle\Entity\Brand 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\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.