https://baadhi.mink67.com/

Method
GET
HTTP Status
200
IP
9.129.58.35
Profiled on
Token
683ee7

Query Metrics

31 Database Queries
5 Different statements
84.08 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 10.37 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, c2_.id AS id_46, c2_.name AS name_47, c2_.code AS code_48, c2_.priority AS priority_49, c2_.image AS image_50, p0_.attribut_id AS attribut_id_51, p0_.category_id AS category_id_52, p0_.default_image_id AS default_image_id_53, p0_.agent_id AS agent_id_54, p0_.life_time_id AS life_time_id_55, p0_.shipping_id AS shipping_id_56, p0_.suppliers_id AS suppliers_id_57, c2_.department_id AS department_id_58 FROM product p0_ INNER JOIN attribut a1_ ON p0_.attribut_id = a1_.id INNER JOIN category c2_ ON p0_.category_id = c2_.id INNER JOIN image i3_ ON p0_.id = i3_.product_id WHERE p0_.deleted_at IS NULL AND a1_.unit_discount IS NOT NULL AND p0_.enabled = ? AND p0_.is_collection = ? ORDER BY FIELD(c2_.priority, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ASC LIMIT 36
Parameters: 
[
  1
  0
  1
  2
  3
  4
  5
  6
  7
  8
  9
  10
  11
  12
  13
  14
  15
  16
  17
  19
  20
  21
  22
  23
  24
  25
  26
  27
  28
  29
  30
  31
  32
  33
  34
  35
  36
  37
  38
  39
  40
  41
  42
  43
  44
  45
  46
  47
  48
  49
  50
  null
]
View formatted query    View runnable query    Explain query
2 48.49 ms 
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.code AS code_2, d0_.created_at AS created_at_3, d0_.updated_at AS updated_at_4, d0_.deleted_at AS deleted_at_5, d0_.deleted_by AS deleted_by_6, d0_.slug AS slug_7 FROM department d0_ INNER JOIN category c1_ ON d0_.id = c1_.department_id INNER JOIN product p2_ ON c1_.id = p2_.category_id ORDER BY p2_.name ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
3 14.16 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, p0_.attribut_id AS attribut_id_29, p0_.category_id AS category_id_30, p0_.default_image_id AS default_image_id_31, p0_.agent_id AS agent_id_32, p0_.life_time_id AS life_time_id_33, p0_.shipping_id AS shipping_id_34, p0_.suppliers_id AS suppliers_id_35 FROM product p0_ INNER JOIN image i1_ ON p0_.id = i1_.product_id INNER JOIN attribut a2_ ON p0_.attribut_id = a2_.id INNER JOIN category c3_ ON p0_.category_id = c3_.id LEFT JOIN product p4_ ON (p0_.category_id = p4_.category_id AND p0_.id < p4_.id) INNER JOIN supplier s5_ ON p0_.suppliers_id = s5_.id WHERE p0_.deleted_at IS NULL AND a2_.unit_discount IS NOT NULL AND i1_.filename IS NOT NULL AND c3_.department_id IS NOT NULL AND p0_.enabled = ? AND p0_.is_collection = ? AND s5_.id IS NOT NULL GROUP BY p0_.id HAVING COUNT(p0_.id) < 6 ORDER BY FIELD(c3_.priority, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ASC
Parameters: 
[
  1
  0
  1
  2
  3
  4
  5
  6
  7
  8
  9
  10
  11
  12
  13
  14
  15
  16
  17
  null
]
View formatted query    View runnable query    Explain query
4 0.92 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: 
[
  851
]
View formatted query    View runnable query    Explain query
5 1.65 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: 
[
  851
]
View formatted query    View runnable query    Explain query
6 0.32 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: 
[
  852
]
View formatted query    View runnable query    Explain query
7 0.26 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: 
[
  852
]
View formatted query    View runnable query    Explain query
8 0.26 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: 
[
  853
]
View formatted query    View runnable query    Explain query
9 0.26 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: 
[
  853
]
View formatted query    View runnable query    Explain query
10 0.27 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: 
[
  854
]
View formatted query    View runnable query    Explain query
11 0.32 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: 
[
  854
]
View formatted query    View runnable query    Explain query
12 0.29 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: 
[
  855
]
View formatted query    View runnable query    Explain query
13 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: 
[
  855
]
View formatted query    View runnable query    Explain query
14 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: 
[
  856
]
View formatted query    View runnable query    Explain query
15 0.34 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: 
[
  856
]
View formatted query    View runnable query    Explain query
16 0.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: 
[
  857
]
View formatted query    View runnable query    Explain query
17 0.41 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: 
[
  857
]
View formatted query    View runnable query    Explain query
18 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: 
[
  858
]
View formatted query    View runnable query    Explain query
19 0.36 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: 
[
  858
]
View formatted query    View runnable query    Explain query
20 0.46 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: 
[
  859
]
View formatted query    View runnable query    Explain query
21 0.30 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: 
[
  859
]
View formatted query    View runnable query    Explain query
22 0.35 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: 
[
  860
]
View formatted query    View runnable query    Explain query
23 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: 
[
  860
]
View formatted query    View runnable query    Explain query
24 0.32 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: 
[
  861
]
View formatted query    View runnable query    Explain query
25 0.29 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: 
[
  861
]
View formatted query    View runnable query    Explain query
26 0.28 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: 
[
  862
]
View formatted query    View runnable query    Explain query
27 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: 
[
  862
]
View formatted query    View runnable query    Explain query
28 0.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: 
[
  863
]
View formatted query    View runnable query    Explain query
29 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: 
[
  863
]
View formatted query    View runnable query    Explain query
30 0.27 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: 
[
  864
]
View formatted query    View runnable query    Explain query
31 0.30 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: 
[
  864
]
View formatted query    View runnable query    Explain query

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\Department No errors.
App\Entity\Product\Product No errors.
App\Entity\Config\Transport No errors.
App\Entity\Configuration No errors.
App\Entity\Product\Attribut No errors.
App\Entity\Product\Category 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\PlacePrice No errors.
App\Entity\Supplier\Activity No errors.