GET https://belanmeziane.shop/

Query Metrics

12 Database Queries
7 Different statements
5.57 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.60 ms
SELECT c0_.id AS id_0, c0_.first_name AS first_name_1, c0_.last_name AS last_name_2, c0_.text_comment AS text_comment_3, c0_.created_at AS created_at_4 FROM comment c0_ ORDER BY c0_.id ASC LIMIT 3
Parameters:
[]
2 0.46 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.name_arb AS name_arb_3 FROM category t0
Parameters:
[]
3 0.56 ms
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.name_arb AS name_arb_2, p0_.description AS description_3, p0_.description_arb AS description_arb_4, p0_.price AS price_5, p0_.promo AS promo_6, p0_.stockage AS stockage_7, i1_.id AS id_8, i1_.name AS name_9, c2_.id AS id_10, c2_.name AS name_11, c2_.name_arb AS name_arb_12 FROM product p0_ INNER JOIN image i1_ ON p0_.id = i1_.product_id INNER JOIN category c2_ ON p0_.category_id = c2_.id WHERE p0_.category_id = ?) dctrn_result_inner ORDER BY id_0 DESC) dctrn_result LIMIT 15
Parameters:
[
  15
]
4 0.56 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.name_arb AS name_arb_2, p0_.description AS description_3, p0_.description_arb AS description_arb_4, p0_.price AS price_5, p0_.promo AS promo_6, p0_.stockage AS stockage_7, i1_.id AS id_8, i1_.name AS name_9, c2_.id AS id_10, c2_.name AS name_11, c2_.name_arb AS name_arb_12, p0_.category_id AS category_id_13, i1_.product_id AS product_id_14 FROM product p0_ INNER JOIN image i1_ ON p0_.id = i1_.product_id INNER JOIN category c2_ ON p0_.category_id = c2_.id WHERE p0_.category_id = ? AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.id DESC
Parameters:
[
  15
  244
  241
  239
  238
  236
  235
  234
  233
  232
  231
  230
  229
  228
  227
  226
]
5 0.43 ms
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, price_5 FROM (SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.name_arb AS name_arb_2, p0_.description AS description_3, p0_.description_arb AS description_arb_4, p0_.price AS price_5, p0_.promo AS promo_6, p0_.stockage AS stockage_7, i1_.id AS id_8, i1_.name AS name_9, c2_.id AS id_10, c2_.name AS name_11, c2_.name_arb AS name_arb_12 FROM product p0_ INNER JOIN image i1_ ON p0_.id = i1_.product_id INNER JOIN category c2_ ON p0_.category_id = c2_.id WHERE p0_.category_id = ?) dctrn_result_inner ORDER BY price_5 ASC) dctrn_result LIMIT 15
Parameters:
[
  16
]
6 0.47 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.name_arb AS name_arb_2, p0_.description AS description_3, p0_.description_arb AS description_arb_4, p0_.price AS price_5, p0_.promo AS promo_6, p0_.stockage AS stockage_7, i1_.id AS id_8, i1_.name AS name_9, c2_.id AS id_10, c2_.name AS name_11, c2_.name_arb AS name_arb_12, p0_.category_id AS category_id_13, i1_.product_id AS product_id_14 FROM product p0_ INNER JOIN image i1_ ON p0_.id = i1_.product_id INNER JOIN category c2_ ON p0_.category_id = c2_.id WHERE p0_.category_id = ? AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.price ASC
Parameters:
[
  16
  216
  213
  217
  218
  210
  211
  215
  209
  214
  212
  219
]
7 0.54 ms
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, price_5 FROM (SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.name_arb AS name_arb_2, p0_.description AS description_3, p0_.description_arb AS description_arb_4, p0_.price AS price_5, p0_.promo AS promo_6, p0_.stockage AS stockage_7, i1_.id AS id_8, i1_.name AS name_9, c2_.id AS id_10, c2_.name AS name_11, c2_.name_arb AS name_arb_12 FROM product p0_ INNER JOIN image i1_ ON p0_.id = i1_.product_id INNER JOIN category c2_ ON p0_.category_id = c2_.id WHERE p0_.category_id = ?) dctrn_result_inner ORDER BY price_5 ASC) dctrn_result LIMIT 15
Parameters:
[
  3
]
8 0.41 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.name_arb AS name_arb_2, p0_.description AS description_3, p0_.description_arb AS description_arb_4, p0_.price AS price_5, p0_.promo AS promo_6, p0_.stockage AS stockage_7, i1_.id AS id_8, i1_.name AS name_9, c2_.id AS id_10, c2_.name AS name_11, c2_.name_arb AS name_arb_12, p0_.category_id AS category_id_13, i1_.product_id AS product_id_14 FROM product p0_ INNER JOIN image i1_ ON p0_.id = i1_.product_id INNER JOIN category c2_ ON p0_.category_id = c2_.id WHERE p0_.category_id = ? AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.price ASC
Parameters:
[
  3
  81
  80
  86
  83
  120
  182
  188
  100
  101
  117
  196
  78
  110
  205
  114
]
9 0.35 ms
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, price_5 FROM (SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.name_arb AS name_arb_2, p0_.description AS description_3, p0_.description_arb AS description_arb_4, p0_.price AS price_5, p0_.promo AS promo_6, p0_.stockage AS stockage_7, i1_.id AS id_8, i1_.name AS name_9, c2_.id AS id_10, c2_.name AS name_11, c2_.name_arb AS name_arb_12 FROM product p0_ INNER JOIN image i1_ ON p0_.id = i1_.product_id INNER JOIN category c2_ ON p0_.category_id = c2_.id WHERE p0_.category_id = ?) dctrn_result_inner ORDER BY price_5 ASC) dctrn_result LIMIT 15
Parameters:
[
  9
]
10 0.50 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.name_arb AS name_arb_2, p0_.description AS description_3, p0_.description_arb AS description_arb_4, p0_.price AS price_5, p0_.promo AS promo_6, p0_.stockage AS stockage_7, i1_.id AS id_8, i1_.name AS name_9, c2_.id AS id_10, c2_.name AS name_11, c2_.name_arb AS name_arb_12, p0_.category_id AS category_id_13, i1_.product_id AS product_id_14 FROM product p0_ INNER JOIN image i1_ ON p0_.id = i1_.product_id INNER JOIN category c2_ ON p0_.category_id = c2_.id WHERE p0_.category_id = ? AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.price ASC
Parameters:
[
  9
  43
  48
  49
  50
  51
  46
  27
  47
  36
  45
  32
  65
  28
  29
  33
]
11 0.30 ms
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, price_5 FROM (SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.name_arb AS name_arb_2, p0_.description AS description_3, p0_.description_arb AS description_arb_4, p0_.price AS price_5, p0_.promo AS promo_6, p0_.stockage AS stockage_7, i1_.id AS id_8, i1_.name AS name_9, c2_.id AS id_10, c2_.name AS name_11, c2_.name_arb AS name_arb_12 FROM product p0_ INNER JOIN image i1_ ON p0_.id = i1_.product_id INNER JOIN category c2_ ON p0_.category_id = c2_.id WHERE p0_.category_id = ?) dctrn_result_inner ORDER BY price_5 ASC) dctrn_result LIMIT 15
Parameters:
[
  5
]
12 0.37 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.name_arb AS name_arb_2, p0_.description AS description_3, p0_.description_arb AS description_arb_4, p0_.price AS price_5, p0_.promo AS promo_6, p0_.stockage AS stockage_7, i1_.id AS id_8, i1_.name AS name_9, c2_.id AS id_10, c2_.name AS name_11, c2_.name_arb AS name_arb_12, p0_.category_id AS category_id_13, i1_.product_id AS product_id_14 FROM product p0_ INNER JOIN image i1_ ON p0_.id = i1_.product_id INNER JOIN category c2_ ON p0_.category_id = c2_.id WHERE p0_.category_id = ? AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.price ASC
Parameters:
[
  5
  155
  16
  156
  220
  157
  154
  133
  123
  121
  221
  122
]

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\Comment No errors.
App\Entity\Product No errors.
App\Entity\Category
  • The association App\Entity\Category#produits refers to the owning side field App\Entity\Product#categorie which does not exist.
App\Entity\Image No errors.