Query Metrics
7
Database Queries
7
Different statements
3.98 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.68 ms (42.25%) |
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:
[
"1645"
]
|
0.62 ms (15.66%) |
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:
[
"offer"
]
|
0.55 ms (13.91%) |
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:
[
1645
]
|
0.33 ms (8.36%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.created_at AS created_at_4, t0.email AS email_5, t0.description AS description_6, t0.is_valid AS is_valid_7, t0.full_name AS full_name_8, t0.tel AS tel_9, t0.address AS address_10, t0.city AS city_11, t0.ice AS ice_12, t0.rc AS rc_13, t0.simulate_username AS simulate_username_14, t0.simulate_password AS simulate_password_15, t0.cover_image AS cover_image_16, t0.path_certimage AS path_certimage_17, t0.path_cvimage AS path_cvimage_18, t0.path_rcimage AS path_rcimage_19, t0.path_ice_image AS path_ice_image_20, t0.path_ifimage AS path_ifimage_21, t0.identifiant_fiscale AS identifiant_fiscale_22, t0.identity_card AS identity_card_23, t0.bank_details AS bank_details_24, t0.address_collecte AS address_collecte_25, t0.delivery_intra AS delivery_intra_26, t0.delivery_inter AS delivery_inter_27, t0.limited_amount AS limited_amount_28, t0.num_rib AS num_rib_29, t0.user_id AS user_id_30 FROM vendor t0 WHERE t0.id = ?
Parameters:
[
1
]
|
0.30 ms (7.56%) |
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:
[
1645
]
|
0.27 ms (6.83%) |
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:
[
1645
]
|
0.22 ms (5.42%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3 FROM brand t0 WHERE t0.id = ?
Parameters:
[
69
]
|
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. |
App\Entity\User | No errors. |
App\Flexy\ShopBundle\Entity\Product\ImportExcel | No errors. |
App\Flexy\ShopBundle\Entity\Vendor\deliverycity | No errors. |