https://boutique.pmd-developper.com/article/cle-usb/cle-usb-16go-2-0/14

Query Metrics

60 Database Queries
14 Different statements
19.48 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.98 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.price AS price_3, t0.description AS description_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.enabled AS enabled_7, t0.quantity AS quantity_8, t0.buying_price AS buying_price_9, t0.etat AS etat_10, t0.qty_reel AS qty_reel_11, t0.label AS label_12, t0.reduction AS reduction_13, t0.status AS status_14, t0.ref AS ref_15, t0.detail AS detail_16, t0.category_id AS category_id_17, t0.brand_id AS brand_id_18 FROM article t0 WHERE t0.id = ?
Parameters:
[
  "14"
]
2 0.38 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.is_active AS is_active_3, t0.slug AS slug_4, t0.category2_id AS category2_id_5 FROM category t0 WHERE t0.id = ?
Parameters:
[
  3
]
3 0.36 ms
SELECT count(DISTINCT a0_.id) AS sclr_0 FROM article a0_ WHERE a0_.enabled = 1
Parameters:
[]
4 0.27 ms
SELECT DISTINCT a0_.id AS id_0 FROM article a0_ WHERE a0_.enabled = 1 LIMIT 1
Parameters:
[]
5 0.44 ms
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.price AS price_2, a0_.description AS description_3, a0_.created_at AS created_at_4, a0_.updated_at AS updated_at_5, a0_.enabled AS enabled_6, a0_.quantity AS quantity_7, a0_.buying_price AS buying_price_8, a0_.etat AS etat_9, a0_.qty_reel AS qty_reel_10, a0_.label AS label_11, a0_.reduction AS reduction_12, a0_.status AS status_13, a0_.ref AS ref_14, a0_.detail AS detail_15, a0_.category_id AS category_id_16, a0_.brand_id AS brand_id_17 FROM article a0_ WHERE a0_.enabled = 1 AND a0_.id IN (?)
Parameters:
[
  1
]
6 0.45 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.price AS price_3, t0.description AS description_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.enabled AS enabled_7, t0.quantity AS quantity_8, t0.buying_price AS buying_price_9, t0.etat AS etat_10, t0.qty_reel AS qty_reel_11, t0.label AS label_12, t0.reduction AS reduction_13, t0.status AS status_14, t0.ref AS ref_15, t0.detail AS detail_16, t0.category_id AS category_id_17, t0.brand_id AS brand_id_18 FROM article t0 WHERE t0.enabled = ? AND t0.etat = ? LIMIT 12
Parameters:
[
  1
  "top"
]
7 0.31 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.price AS price_3, t0.description AS description_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.enabled AS enabled_7, t0.quantity AS quantity_8, t0.buying_price AS buying_price_9, t0.etat AS etat_10, t0.qty_reel AS qty_reel_11, t0.label AS label_12, t0.reduction AS reduction_13, t0.status AS status_14, t0.ref AS ref_15, t0.detail AS detail_16, t0.category_id AS category_id_17, t0.brand_id AS brand_id_18 FROM article t0
Parameters:
[]
8 0.87 ms
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.price AS price_2, a0_.description AS description_3, a0_.created_at AS created_at_4, a0_.updated_at AS updated_at_5, a0_.enabled AS enabled_6, a0_.quantity AS quantity_7, a0_.buying_price AS buying_price_8, a0_.etat AS etat_9, a0_.qty_reel AS qty_reel_10, a0_.label AS label_11, a0_.reduction AS reduction_12, a0_.status AS status_13, a0_.ref AS ref_14, a0_.detail AS detail_15, RAND() AS sclr_16, a0_.category_id AS category_id_17, a0_.brand_id AS brand_id_18 FROM article a0_ WHERE a0_.enabled = 1 AND a0_.id <> ? ORDER BY sclr_16 ASC LIMIT 20
Parameters:
[
  14
]
9 0.56 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM image t0 INNER JOIN article_image ON t0.id = article_image.image_id WHERE article_image.article_id = ?
Parameters:
[
  14
]
10 0.54 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.is_active AS is_active_3, t0.slug AS slug_4, t0.category2_id AS category2_id_5 FROM category t0
Parameters:
[]
11 0.31 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.category3_id AS category3_id_5 FROM category2 t0 WHERE t0.id = ?
Parameters:
[
  1
]
12 0.36 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.icon AS icon_4 FROM category3 t0 WHERE t0.id = ?
Parameters:
[
  1
]
13 0.33 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.category3_id AS category3_id_5 FROM category2 t0 WHERE t0.id = ?
Parameters:
[
  2
]
14 0.35 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.category3_id AS category3_id_5 FROM category2 t0 WHERE t0.id = ?
Parameters:
[
  3
]
15 0.26 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.category3_id AS category3_id_5 FROM category2 t0 WHERE t0.id = ?
Parameters:
[
  4
]
16 0.33 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.category3_id AS category3_id_5 FROM category2 t0 WHERE t0.id = ?
Parameters:
[
  5
]
17 0.28 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.category3_id AS category3_id_5 FROM category2 t0 WHERE t0.id = ?
Parameters:
[
  6
]
18 0.40 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.rating AS rating_4, t0.label AS label_5, t0.article_id AS article_id_6, t0.user_id AS user_id_7 FROM comment t0 WHERE t0.article_id = ?
Parameters:
[
  14
]
19 0.24 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.rating AS rating_4, t0.label AS label_5, t0.article_id AS article_id_6, t0.user_id AS user_id_7 FROM comment t0 WHERE t0.article_id = ?
Parameters:
[
  14
]
20 0.33 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.article_id AS article_id_4 FROM article_option t0 WHERE t0.article_id = ?
Parameters:
[
  14
]
21 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM image t0 INNER JOIN article_image ON t0.id = article_image.image_id WHERE article_image.article_id = ?
Parameters:
[
  4
]
22 0.26 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.rating AS rating_4, t0.label AS label_5, t0.article_id AS article_id_6, t0.user_id AS user_id_7 FROM comment t0 WHERE t0.article_id = ?
Parameters:
[
  4
]
23 0.28 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.rating AS rating_4, t0.label AS label_5, t0.article_id AS article_id_6, t0.user_id AS user_id_7 FROM comment t0 WHERE t0.article_id = ?
Parameters:
[
  4
]
24 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM image t0 INNER JOIN article_image ON t0.id = article_image.image_id WHERE article_image.article_id = ?
Parameters:
[
  6
]
25 0.33 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.rating AS rating_4, t0.label AS label_5, t0.article_id AS article_id_6, t0.user_id AS user_id_7 FROM comment t0 WHERE t0.article_id = ?
Parameters:
[
  6
]
26 0.22 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.rating AS rating_4, t0.label AS label_5, t0.article_id AS article_id_6, t0.user_id AS user_id_7 FROM comment t0 WHERE t0.article_id = ?
Parameters:
[
  6
]
27 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM image t0 INNER JOIN article_image ON t0.id = article_image.image_id WHERE article_image.article_id = ?
Parameters:
[
  10
]
28 0.28 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.rating AS rating_4, t0.label AS label_5, t0.article_id AS article_id_6, t0.user_id AS user_id_7 FROM comment t0 WHERE t0.article_id = ?
Parameters:
[
  10
]
29 0.26 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.rating AS rating_4, t0.label AS label_5, t0.article_id AS article_id_6, t0.user_id AS user_id_7 FROM comment t0 WHERE t0.article_id = ?
Parameters:
[
  10
]
30 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM image t0 INNER JOIN article_image ON t0.id = article_image.image_id WHERE article_image.article_id = ?
Parameters:
[
  11
]
31 0.30 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.rating AS rating_4, t0.label AS label_5, t0.article_id AS article_id_6, t0.user_id AS user_id_7 FROM comment t0 WHERE t0.article_id = ?
Parameters:
[
  11
]
32 0.26 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.rating AS rating_4, t0.label AS label_5, t0.article_id AS article_id_6, t0.user_id AS user_id_7 FROM comment t0 WHERE t0.article_id = ?
Parameters:
[
  11
]
33 0.32 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM image t0 INNER JOIN article_image ON t0.id = article_image.image_id WHERE article_image.article_id = ?
Parameters:
[
  2
]
34 0.29 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.rating AS rating_4, t0.label AS label_5, t0.article_id AS article_id_6, t0.user_id AS user_id_7 FROM comment t0 WHERE t0.article_id = ?
Parameters:
[
  2
]
35 0.22 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.rating AS rating_4, t0.label AS label_5, t0.article_id AS article_id_6, t0.user_id AS user_id_7 FROM comment t0 WHERE t0.article_id = ?
Parameters:
[
  2
]
36 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM image t0 INNER JOIN article_image ON t0.id = article_image.image_id WHERE article_image.article_id = ?
Parameters:
[
  12
]
37 0.25 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.rating AS rating_4, t0.label AS label_5, t0.article_id AS article_id_6, t0.user_id AS user_id_7 FROM comment t0 WHERE t0.article_id = ?
Parameters:
[
  12
]
38 0.21 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.rating AS rating_4, t0.label AS label_5, t0.article_id AS article_id_6, t0.user_id AS user_id_7 FROM comment t0 WHERE t0.article_id = ?
Parameters:
[
  12
]
39 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM image t0 INNER JOIN article_image ON t0.id = article_image.image_id WHERE article_image.article_id = ?
Parameters:
[
  5
]
40 0.27 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.rating AS rating_4, t0.label AS label_5, t0.article_id AS article_id_6, t0.user_id AS user_id_7 FROM comment t0 WHERE t0.article_id = ?
Parameters:
[
  5
]
41 0.28 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.rating AS rating_4, t0.label AS label_5, t0.article_id AS article_id_6, t0.user_id AS user_id_7 FROM comment t0 WHERE t0.article_id = ?
Parameters:
[
  5
]
42 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM image t0 INNER JOIN article_image ON t0.id = article_image.image_id WHERE article_image.article_id = ?
Parameters:
[
  8
]
43 0.31 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.rating AS rating_4, t0.label AS label_5, t0.article_id AS article_id_6, t0.user_id AS user_id_7 FROM comment t0 WHERE t0.article_id = ?
Parameters:
[
  8
]
44 0.23 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.rating AS rating_4, t0.label AS label_5, t0.article_id AS article_id_6, t0.user_id AS user_id_7 FROM comment t0 WHERE t0.article_id = ?
Parameters:
[
  8
]
45 0.32 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM image t0 INNER JOIN article_image ON t0.id = article_image.image_id WHERE article_image.article_id = ?
Parameters:
[
  13
]
46 0.30 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.rating AS rating_4, t0.label AS label_5, t0.article_id AS article_id_6, t0.user_id AS user_id_7 FROM comment t0 WHERE t0.article_id = ?
Parameters:
[
  13
]
47 0.23 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.rating AS rating_4, t0.label AS label_5, t0.article_id AS article_id_6, t0.user_id AS user_id_7 FROM comment t0 WHERE t0.article_id = ?
Parameters:
[
  13
]
48 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM image t0 INNER JOIN article_image ON t0.id = article_image.image_id WHERE article_image.article_id = ?
Parameters:
[
  9
]
49 0.26 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.rating AS rating_4, t0.label AS label_5, t0.article_id AS article_id_6, t0.user_id AS user_id_7 FROM comment t0 WHERE t0.article_id = ?
Parameters:
[
  9
]
50 0.24 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.rating AS rating_4, t0.label AS label_5, t0.article_id AS article_id_6, t0.user_id AS user_id_7 FROM comment t0 WHERE t0.article_id = ?
Parameters:
[
  9
]
51 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM image t0 INNER JOIN article_image ON t0.id = article_image.image_id WHERE article_image.article_id = ?
Parameters:
[
  3
]
52 0.28 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.rating AS rating_4, t0.label AS label_5, t0.article_id AS article_id_6, t0.user_id AS user_id_7 FROM comment t0 WHERE t0.article_id = ?
Parameters:
[
  3
]
53 0.22 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.rating AS rating_4, t0.label AS label_5, t0.article_id AS article_id_6, t0.user_id AS user_id_7 FROM comment t0 WHERE t0.article_id = ?
Parameters:
[
  3
]
54 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM image t0 INNER JOIN article_image ON t0.id = article_image.image_id WHERE article_image.article_id = ?
Parameters:
[
  1
]
55 0.24 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.rating AS rating_4, t0.label AS label_5, t0.article_id AS article_id_6, t0.user_id AS user_id_7 FROM comment t0 WHERE t0.article_id = ?
Parameters:
[
  1
]
56 0.24 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.rating AS rating_4, t0.label AS label_5, t0.article_id AS article_id_6, t0.user_id AS user_id_7 FROM comment t0 WHERE t0.article_id = ?
Parameters:
[
  1
]
57 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM image t0 INNER JOIN article_image ON t0.id = article_image.image_id WHERE article_image.article_id = ?
Parameters:
[
  7
]
58 0.28 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.rating AS rating_4, t0.label AS label_5, t0.article_id AS article_id_6, t0.user_id AS user_id_7 FROM comment t0 WHERE t0.article_id = ?
Parameters:
[
  7
]
59 0.26 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.rating AS rating_4, t0.label AS label_5, t0.article_id AS article_id_6, t0.user_id AS user_id_7 FROM comment t0 WHERE t0.article_id = ?
Parameters:
[
  7
]
60 0.26 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.is_active AS is_active_3, t0.slug AS slug_4, t0.category2_id AS category2_id_5 FROM category 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\Entity\Article No errors.
App\Entity\Category No errors.
App\Entity\Brand No errors.
App\Entity\ArticleOption No errors.
App\Entity\Comment No errors.
App\Entity\User No errors.
App\Entity\ArticleBuy No errors.
App\Entity\Image No errors.
App\Entity\Category2 No errors.
App\Entity\Category3 No errors.