Query Metrics
40
Database Queries
6
Different statements
27.37 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.15 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.priority AS priority_4, t0.image AS image_5, t0.department_id AS department_id_6 FROM category t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"produits laitiers(beurre, lait et fromage)"
]
|
| 2 | 1.98 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.enabled AS enabled_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p0_.slug AS slug_6, p0_.has_publicity AS has_publicity_7, p0_.code AS code_8, p0_.stockcode AS stockcode_9, p0_.sales_unit AS sales_unit_10, p0_.view AS view_11, p0_.nb_buyers AS nb_buyers_12, p0_.varieties AS varieties_13, p0_.quality AS quality_14, p0_.colors AS colors_15, p0_.sizes AS sizes_16, p0_.origin AS origin_17, p0_.rate AS rate_18, p0_.expiration_date AS expiration_date_19, p0_.production_date AS production_date_20, p0_.nb_rates AS nb_rates_21, p0_.deleted_at AS deleted_at_22, p0_.flavors AS flavors_23, p0_.is_grouped AS is_grouped_24, p0_.group_slug AS group_slug_25, p0_.is_collection AS is_collection_26, p0_.is_agromwinda_promotion AS is_agromwinda_promotion_27, p0_.enabled_provinces AS enabled_provinces_28, a1_.id AS id_29, a1_.stock AS stock_30, a1_.taxe AS taxe_31, a1_.code AS code_32, a1_.price AS price_33, a1_.promotion AS promotion_34, a1_.rate AS rate_35, a1_.unit_discount AS unit_discount_36, a1_.weight AS weight_37, a1_.weight_kg AS weight_kg_38, a1_.min_purchase AS min_purchase_39, a1_.max_purchase AS max_purchase_40, a1_.created_at AS created_at_41, a1_.updated_at AS updated_at_42, a1_.deleted_at AS deleted_at_43, a1_.deleted_by AS deleted_by_44, a1_.slug AS slug_45, i2_.id AS id_46, i2_.filename AS filename_47, i2_.path AS path_48, i2_.created_at AS created_at_49, i2_.updated_at AS updated_at_50, i2_.deleted_at AS deleted_at_51, i2_.deleted_by AS deleted_by_52, i2_.slug AS slug_53, c3_.id AS id_54, c3_.name AS name_55, c3_.code AS code_56, c3_.priority AS priority_57, c3_.image AS image_58, p0_.attribut_id AS attribut_id_59, p0_.category_id AS category_id_60, p0_.default_image_id AS default_image_id_61, p0_.agent_id AS agent_id_62, p0_.life_time_id AS life_time_id_63, p0_.shipping_id AS shipping_id_64, p0_.suppliers_id AS suppliers_id_65, i2_.product_id AS product_id_66, i2_.supplier_activity_id AS supplier_activity_id_67, c3_.department_id AS department_id_68 FROM product p0_ INNER JOIN attribut a1_ ON p0_.attribut_id = a1_.id INNER JOIN image i2_ ON p0_.id = i2_.product_id INNER JOIN category c3_ ON p0_.category_id = c3_.id INNER JOIN department d4_ ON c3_.department_id = d4_.id WHERE p0_.deleted_at IS NULL AND a1_.unit_discount IS NOT NULL AND p0_.enabled = ? AND c3_.name = ? AND i2_.filename IS NOT NULL ORDER BY p0_.id DESC
Parameters:
[ 1 "produits laitiers(beurre, lait et fromage)" ] |
| 3 | 1.33 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.enabled AS enabled_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.slug AS slug_7, t0.has_publicity AS has_publicity_8, t0.code AS code_9, t0.stockcode AS stockcode_10, t0.sales_unit AS sales_unit_11, t0.view AS view_12, t0.nb_buyers AS nb_buyers_13, t0.varieties AS varieties_14, t0.quality AS quality_15, t0.colors AS colors_16, t0.sizes AS sizes_17, t0.origin AS origin_18, t0.rate AS rate_19, t0.expiration_date AS expiration_date_20, t0.production_date AS production_date_21, t0.nb_rates AS nb_rates_22, t0.deleted_at AS deleted_at_23, t0.flavors AS flavors_24, t0.is_grouped AS is_grouped_25, t0.group_slug AS group_slug_26, t0.is_collection AS is_collection_27, t0.is_agromwinda_promotion AS is_agromwinda_promotion_28, t0.enabled_provinces AS enabled_provinces_29, t0.attribut_id AS attribut_id_30, t0.category_id AS category_id_31, t0.default_image_id AS default_image_id_32, t0.agent_id AS agent_id_33, t0.life_time_id AS life_time_id_34, t0.shipping_id AS shipping_id_35, t0.suppliers_id AS suppliers_id_36 FROM product t0 WHERE t0.category_id = ?
Parameters:
[
45
]
|
| 4 | 1.01 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.path AS path_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.deleted_by AS deleted_by_7, t0.slug AS slug_8, t0.product_id AS product_id_9, t0.supplier_activity_id AS supplier_activity_id_10 FROM image t0 WHERE t0.product_id = ?
Parameters:
[
570
]
|
| 5 | 0.53 ms |
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.taxe AS taxe_3, t0.code AS code_4, t0.price AS price_5, t0.promotion AS promotion_6, t0.rate AS rate_7, t0.unit_discount AS unit_discount_8, t0.weight AS weight_9, t0.weight_kg AS weight_kg_10, t0.min_purchase AS min_purchase_11, t0.max_purchase AS max_purchase_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.deleted_at AS deleted_at_15, t0.deleted_by AS deleted_by_16, t0.slug AS slug_17 FROM attribut t0 WHERE t0.id = ?
Parameters:
[
571
]
|
| 6 | 0.50 ms |
SELECT t0.id AS id_1, t0.place_type AS place_type_2, t0.price AS price_3, t0.place_name AS place_name_4, t0.product_id AS product_id_5 FROM place_price t0 WHERE t0.product_id = ?
Parameters:
[
570
]
|
| 7 | 0.42 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.path AS path_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.deleted_by AS deleted_by_7, t0.slug AS slug_8, t0.product_id AS product_id_9, t0.supplier_activity_id AS supplier_activity_id_10 FROM image t0 WHERE t0.product_id = ?
Parameters:
[
667
]
|
| 8 | 0.60 ms |
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.taxe AS taxe_3, t0.code AS code_4, t0.price AS price_5, t0.promotion AS promotion_6, t0.rate AS rate_7, t0.unit_discount AS unit_discount_8, t0.weight AS weight_9, t0.weight_kg AS weight_kg_10, t0.min_purchase AS min_purchase_11, t0.max_purchase AS max_purchase_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.deleted_at AS deleted_at_15, t0.deleted_by AS deleted_by_16, t0.slug AS slug_17 FROM attribut t0 WHERE t0.id = ?
Parameters:
[
668
]
|
| 9 | 0.49 ms |
SELECT t0.id AS id_1, t0.place_type AS place_type_2, t0.price AS price_3, t0.place_name AS place_name_4, t0.product_id AS product_id_5 FROM place_price t0 WHERE t0.product_id = ?
Parameters:
[
667
]
|
| 10 | 0.83 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.path AS path_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.deleted_by AS deleted_by_7, t0.slug AS slug_8, t0.product_id AS product_id_9, t0.supplier_activity_id AS supplier_activity_id_10 FROM image t0 WHERE t0.product_id = ?
Parameters:
[
674
]
|
| 11 | 0.61 ms |
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.taxe AS taxe_3, t0.code AS code_4, t0.price AS price_5, t0.promotion AS promotion_6, t0.rate AS rate_7, t0.unit_discount AS unit_discount_8, t0.weight AS weight_9, t0.weight_kg AS weight_kg_10, t0.min_purchase AS min_purchase_11, t0.max_purchase AS max_purchase_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.deleted_at AS deleted_at_15, t0.deleted_by AS deleted_by_16, t0.slug AS slug_17 FROM attribut t0 WHERE t0.id = ?
Parameters:
[
675
]
|
| 12 | 0.31 ms |
SELECT t0.id AS id_1, t0.place_type AS place_type_2, t0.price AS price_3, t0.place_name AS place_name_4, t0.product_id AS product_id_5 FROM place_price t0 WHERE t0.product_id = ?
Parameters:
[
674
]
|
| 13 | 0.31 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.path AS path_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.deleted_by AS deleted_by_7, t0.slug AS slug_8, t0.product_id AS product_id_9, t0.supplier_activity_id AS supplier_activity_id_10 FROM image t0 WHERE t0.product_id = ?
Parameters:
[
710
]
|
| 14 | 0.70 ms |
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.taxe AS taxe_3, t0.code AS code_4, t0.price AS price_5, t0.promotion AS promotion_6, t0.rate AS rate_7, t0.unit_discount AS unit_discount_8, t0.weight AS weight_9, t0.weight_kg AS weight_kg_10, t0.min_purchase AS min_purchase_11, t0.max_purchase AS max_purchase_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.deleted_at AS deleted_at_15, t0.deleted_by AS deleted_by_16, t0.slug AS slug_17 FROM attribut t0 WHERE t0.id = ?
Parameters:
[
711
]
|
| 15 | 0.47 ms |
SELECT t0.id AS id_1, t0.place_type AS place_type_2, t0.price AS price_3, t0.place_name AS place_name_4, t0.product_id AS product_id_5 FROM place_price t0 WHERE t0.product_id = ?
Parameters:
[
710
]
|
| 16 | 0.53 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.path AS path_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.deleted_by AS deleted_by_7, t0.slug AS slug_8, t0.product_id AS product_id_9, t0.supplier_activity_id AS supplier_activity_id_10 FROM image t0 WHERE t0.product_id = ?
Parameters:
[
766
]
|
| 17 | 0.42 ms |
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.taxe AS taxe_3, t0.code AS code_4, t0.price AS price_5, t0.promotion AS promotion_6, t0.rate AS rate_7, t0.unit_discount AS unit_discount_8, t0.weight AS weight_9, t0.weight_kg AS weight_kg_10, t0.min_purchase AS min_purchase_11, t0.max_purchase AS max_purchase_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.deleted_at AS deleted_at_15, t0.deleted_by AS deleted_by_16, t0.slug AS slug_17 FROM attribut t0 WHERE t0.id = ?
Parameters:
[
767
]
|
| 18 | 0.28 ms |
SELECT t0.id AS id_1, t0.place_type AS place_type_2, t0.price AS price_3, t0.place_name AS place_name_4, t0.product_id AS product_id_5 FROM place_price t0 WHERE t0.product_id = ?
Parameters:
[
766
]
|
| 19 | 0.52 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.path AS path_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.deleted_by AS deleted_by_7, t0.slug AS slug_8, t0.product_id AS product_id_9, t0.supplier_activity_id AS supplier_activity_id_10 FROM image t0 WHERE t0.product_id = ?
Parameters:
[
772
]
|
| 20 | 0.61 ms |
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.taxe AS taxe_3, t0.code AS code_4, t0.price AS price_5, t0.promotion AS promotion_6, t0.rate AS rate_7, t0.unit_discount AS unit_discount_8, t0.weight AS weight_9, t0.weight_kg AS weight_kg_10, t0.min_purchase AS min_purchase_11, t0.max_purchase AS max_purchase_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.deleted_at AS deleted_at_15, t0.deleted_by AS deleted_by_16, t0.slug AS slug_17 FROM attribut t0 WHERE t0.id = ?
Parameters:
[
773
]
|
| 21 | 0.50 ms |
SELECT t0.id AS id_1, t0.place_type AS place_type_2, t0.price AS price_3, t0.place_name AS place_name_4, t0.product_id AS product_id_5 FROM place_price t0 WHERE t0.product_id = ?
Parameters:
[
772
]
|
| 22 | 0.48 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.path AS path_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.deleted_by AS deleted_by_7, t0.slug AS slug_8, t0.product_id AS product_id_9, t0.supplier_activity_id AS supplier_activity_id_10 FROM image t0 WHERE t0.product_id = ?
Parameters:
[
773
]
|
| 23 | 1.06 ms |
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.taxe AS taxe_3, t0.code AS code_4, t0.price AS price_5, t0.promotion AS promotion_6, t0.rate AS rate_7, t0.unit_discount AS unit_discount_8, t0.weight AS weight_9, t0.weight_kg AS weight_kg_10, t0.min_purchase AS min_purchase_11, t0.max_purchase AS max_purchase_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.deleted_at AS deleted_at_15, t0.deleted_by AS deleted_by_16, t0.slug AS slug_17 FROM attribut t0 WHERE t0.id = ?
Parameters:
[
774
]
|
| 24 | 0.85 ms |
SELECT t0.id AS id_1, t0.place_type AS place_type_2, t0.price AS price_3, t0.place_name AS place_name_4, t0.product_id AS product_id_5 FROM place_price t0 WHERE t0.product_id = ?
Parameters:
[
773
]
|
| 25 | 0.56 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.path AS path_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.deleted_by AS deleted_by_7, t0.slug AS slug_8, t0.product_id AS product_id_9, t0.supplier_activity_id AS supplier_activity_id_10 FROM image t0 WHERE t0.product_id = ?
Parameters:
[
784
]
|
| 26 | 0.50 ms |
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.taxe AS taxe_3, t0.code AS code_4, t0.price AS price_5, t0.promotion AS promotion_6, t0.rate AS rate_7, t0.unit_discount AS unit_discount_8, t0.weight AS weight_9, t0.weight_kg AS weight_kg_10, t0.min_purchase AS min_purchase_11, t0.max_purchase AS max_purchase_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.deleted_at AS deleted_at_15, t0.deleted_by AS deleted_by_16, t0.slug AS slug_17 FROM attribut t0 WHERE t0.id = ?
Parameters:
[
785
]
|
| 27 | 0.52 ms |
SELECT t0.id AS id_1, t0.place_type AS place_type_2, t0.price AS price_3, t0.place_name AS place_name_4, t0.product_id AS product_id_5 FROM place_price t0 WHERE t0.product_id = ?
Parameters:
[
784
]
|
| 28 | 0.53 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.path AS path_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.deleted_by AS deleted_by_7, t0.slug AS slug_8, t0.product_id AS product_id_9, t0.supplier_activity_id AS supplier_activity_id_10 FROM image t0 WHERE t0.product_id = ?
Parameters:
[
785
]
|
| 29 | 0.79 ms |
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.taxe AS taxe_3, t0.code AS code_4, t0.price AS price_5, t0.promotion AS promotion_6, t0.rate AS rate_7, t0.unit_discount AS unit_discount_8, t0.weight AS weight_9, t0.weight_kg AS weight_kg_10, t0.min_purchase AS min_purchase_11, t0.max_purchase AS max_purchase_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.deleted_at AS deleted_at_15, t0.deleted_by AS deleted_by_16, t0.slug AS slug_17 FROM attribut t0 WHERE t0.id = ?
Parameters:
[
786
]
|
| 30 | 0.89 ms |
SELECT t0.id AS id_1, t0.place_type AS place_type_2, t0.price AS price_3, t0.place_name AS place_name_4, t0.product_id AS product_id_5 FROM place_price t0 WHERE t0.product_id = ?
Parameters:
[
785
]
|
| 31 | 1.33 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.path AS path_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.deleted_by AS deleted_by_7, t0.slug AS slug_8, t0.product_id AS product_id_9, t0.supplier_activity_id AS supplier_activity_id_10 FROM image t0 WHERE t0.product_id = ?
Parameters:
[
786
]
|
| 32 | 0.50 ms |
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.taxe AS taxe_3, t0.code AS code_4, t0.price AS price_5, t0.promotion AS promotion_6, t0.rate AS rate_7, t0.unit_discount AS unit_discount_8, t0.weight AS weight_9, t0.weight_kg AS weight_kg_10, t0.min_purchase AS min_purchase_11, t0.max_purchase AS max_purchase_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.deleted_at AS deleted_at_15, t0.deleted_by AS deleted_by_16, t0.slug AS slug_17 FROM attribut t0 WHERE t0.id = ?
Parameters:
[
787
]
|
| 33 | 0.35 ms |
SELECT t0.id AS id_1, t0.place_type AS place_type_2, t0.price AS price_3, t0.place_name AS place_name_4, t0.product_id AS product_id_5 FROM place_price t0 WHERE t0.product_id = ?
Parameters:
[
786
]
|
| 34 | 0.34 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.path AS path_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.deleted_by AS deleted_by_7, t0.slug AS slug_8, t0.product_id AS product_id_9, t0.supplier_activity_id AS supplier_activity_id_10 FROM image t0 WHERE t0.product_id = ?
Parameters:
[
787
]
|
| 35 | 0.44 ms |
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.taxe AS taxe_3, t0.code AS code_4, t0.price AS price_5, t0.promotion AS promotion_6, t0.rate AS rate_7, t0.unit_discount AS unit_discount_8, t0.weight AS weight_9, t0.weight_kg AS weight_kg_10, t0.min_purchase AS min_purchase_11, t0.max_purchase AS max_purchase_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.deleted_at AS deleted_at_15, t0.deleted_by AS deleted_by_16, t0.slug AS slug_17 FROM attribut t0 WHERE t0.id = ?
Parameters:
[
788
]
|
| 36 | 0.54 ms |
SELECT t0.id AS id_1, t0.place_type AS place_type_2, t0.price AS price_3, t0.place_name AS place_name_4, t0.product_id AS product_id_5 FROM place_price t0 WHERE t0.product_id = ?
Parameters:
[
787
]
|
| 37 | 0.34 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.path AS path_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.deleted_by AS deleted_by_7, t0.slug AS slug_8, t0.product_id AS product_id_9, t0.supplier_activity_id AS supplier_activity_id_10 FROM image t0 WHERE t0.product_id = ?
Parameters:
[
803
]
|
| 38 | 1.20 ms |
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.taxe AS taxe_3, t0.code AS code_4, t0.price AS price_5, t0.promotion AS promotion_6, t0.rate AS rate_7, t0.unit_discount AS unit_discount_8, t0.weight AS weight_9, t0.weight_kg AS weight_kg_10, t0.min_purchase AS min_purchase_11, t0.max_purchase AS max_purchase_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.deleted_at AS deleted_at_15, t0.deleted_by AS deleted_by_16, t0.slug AS slug_17 FROM attribut t0 WHERE t0.id = ?
Parameters:
[
804
]
|
| 39 | 0.68 ms |
SELECT t0.id AS id_1, t0.place_type AS place_type_2, t0.price AS price_3, t0.place_name AS place_name_4, t0.product_id AS product_id_5 FROM place_price t0 WHERE t0.product_id = ?
Parameters:
[
803
]
|
| 40 | 1.36 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.path AS path_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.deleted_by AS deleted_by_7, t0.slug AS slug_8, t0.product_id AS product_id_9, t0.supplier_activity_id AS supplier_activity_id_10 FROM image t0 WHERE t0.product_id = ?
Parameters:
[
822
]
|
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\Entity\Product\Product | No errors. |
| App\Entity\Product\Department | No errors. |
| App\Entity\Product\Category | No errors. |
| App\Entity\Config\Transport | No errors. |
| App\Entity\Configuration | No errors. |
| App\Entity\Product\Attribut | No errors. |
| App\Entity\Product\Image | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Product\LifeTime | No errors. |
| App\Entity\Product\Shipping | No errors. |
| App\Entity\Supplier\Supplier | No errors. |
| App\Entity\Supplier\Activity | No errors. |
| App\Entity\PlacePrice | No errors. |