GET https://dev.boutiquecoquinage.fr/

Query Metrics

126 Database Queries
14 Different statements
252.93 ms Query time
0 Invalid entities
227 Managed entities

Queries

Group similar statements

# Time Info
1 3.41 ms
SELECT * FROM brand as b WHERE (b.logo IS NOT NULL AND b.logo <> '') ORDER BY RAND() LIMIT 25
Parameters:
[]
2 159.71 ms
SELECT DISTINCT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.content AS content_3, p0_.created_at AS created_at_4, p0_.active AS active_5, p0_.code_ean AS code_ean_6, p0_.last_modification AS last_modification_7, p0_.old_price AS old_price_8, p0_.promo AS promo_9, p0_.top AS top_10, p0_.weight AS weight_11, p0_.reference AS reference_12, p0_.valid AS valid_13, p0_.tvarate AS tvarate_14, p0_.brand_id AS brand_id_15 FROM products p0_ INNER JOIN stock s1_ ON (s1_.product_id = p0_.id) WHERE p0_.active = 1 AND p0_.valid = 1 AND s1_.quantity > 0 GROUP BY p0_.reference ORDER BY p0_.last_modification DESC, p0_.name ASC LIMIT 8
Parameters:
[]
3 1.04 ms
SELECT t0.id AS id_1, t0.price_distributor AS price_distributor_2, t0.price_suggested AS price_suggested_3, t0.date_update AS date_update_4, t0.price AS price_5, t0.selected AS selected_6, t0.tvarate AS tvarate_7, t0.product_id AS product_id_8, t0.distributor_id AS distributor_id_9 FROM prices t0 WHERE t0.product_id = ? ORDER BY t0.selected ASC
Parameters:
[
  23607
]
4 0.31 ms
SELECT t0.id AS id_1, t0.date_rating AS date_rating_2, t0.recommanded AS recommanded_3, t0.facility_use AS facility_use_4, t0.quality_price AS quality_price_5, t0.design AS design_6, t0.material AS material_7, t0.pseudo AS pseudo_8, t0.email AS email_9, t0.avis AS avis_10, t0.utile_in AS utile_in_11, t0.utile_out AS utile_out_12, t0.active AS active_13, t0.rating AS rating_14, t0.validated AS validated_15, t0.product_id AS product_id_16 FROM product_rating t0 WHERE t0.product_id = ?
Parameters:
[
  23607
]
5 0.65 ms
SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.feature_line_id AS feature_line_id_3 FROM product_features t0 WHERE t0.product_id = ?
Parameters:
[
  23607
]
6 0.22 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.data AS data_3, t0.attribute_id AS attribute_id_4 FROM features_lines t0 WHERE t0.id = ?
Parameters:
[
  32
]
7 0.25 ms
SELECT t0.id AS id_1, t0.feature AS feature_2 FROM features_list t0 WHERE t0.id = ?
Parameters:
[
  2
]
8 0.18 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.data AS data_3, t0.attribute_id AS attribute_id_4 FROM features_lines t0 WHERE t0.id = ?
Parameters:
[
  195
]
9 0.16 ms
SELECT t0.id AS id_1, t0.feature AS feature_2 FROM features_list t0 WHERE t0.id = ?
Parameters:
[
  3
]
10 0.17 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.data AS data_3, t0.attribute_id AS attribute_id_4 FROM features_lines t0 WHERE t0.id = ?
Parameters:
[
  1768
]
11 0.18 ms
SELECT t0.id AS id_1, t0.feature AS feature_2 FROM features_list t0 WHERE t0.id = ?
Parameters:
[
  12
]
12 0.18 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.data AS data_3, t0.attribute_id AS attribute_id_4 FROM features_lines t0 WHERE t0.id = ?
Parameters:
[
  395
]
13 0.16 ms
SELECT t0.id AS id_1, t0.feature AS feature_2 FROM features_list t0 WHERE t0.id = ?
Parameters:
[
  23
]
14 0.34 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.ref_distributor AS ref_distributor_3, t0.end AS end_4, t0.product_id AS product_id_5, t0.distributor_id AS distributor_id_6 FROM stock t0 WHERE t0.product_id = ?
Parameters:
[
  23607
]
15 0.88 ms
SELECT t0.id AS id_1, t0.active AS active_2, t0.first AS first_3, t0.src AS src_4, t0.product_id AS product_id_5 FROM images t0 WHERE t0.product_id = ? ORDER BY t0.first ASC
Parameters:
[
  23607
]
16 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.description AS description_4, t0.distributors AS distributors_5, t0.distributor_id AS distributor_id_6 FROM brand t0 WHERE t0.id = ?
Parameters:
[
  54
]
17 0.40 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.link AS link_4, t0.position AS position_5, t0.title AS title_6, t0.icon AS icon_7, t0.thumbnail AS thumbnail_8, t0.image AS image_9, t0.margin AS margin_10, t0.description AS description_11, t0.parent_id AS parent_id_12 FROM categories t0 INNER JOIN categories_products ON t0.id = categories_products.categories_id WHERE categories_products.products_id = ?
Parameters:
[
  23607
]
18 0.35 ms
SELECT t0.id AS id_1, t0.price_distributor AS price_distributor_2, t0.price_suggested AS price_suggested_3, t0.date_update AS date_update_4, t0.price AS price_5, t0.selected AS selected_6, t0.tvarate AS tvarate_7, t0.product_id AS product_id_8, t0.distributor_id AS distributor_id_9 FROM prices t0 WHERE t0.product_id = ? ORDER BY t0.selected ASC
Parameters:
[
  23606
]
19 0.31 ms
SELECT t0.id AS id_1, t0.date_rating AS date_rating_2, t0.recommanded AS recommanded_3, t0.facility_use AS facility_use_4, t0.quality_price AS quality_price_5, t0.design AS design_6, t0.material AS material_7, t0.pseudo AS pseudo_8, t0.email AS email_9, t0.avis AS avis_10, t0.utile_in AS utile_in_11, t0.utile_out AS utile_out_12, t0.active AS active_13, t0.rating AS rating_14, t0.validated AS validated_15, t0.product_id AS product_id_16 FROM product_rating t0 WHERE t0.product_id = ?
Parameters:
[
  23606
]
20 0.28 ms
SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.feature_line_id AS feature_line_id_3 FROM product_features t0 WHERE t0.product_id = ?
Parameters:
[
  23606
]
21 0.24 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.data AS data_3, t0.attribute_id AS attribute_id_4 FROM features_lines t0 WHERE t0.id = ?
Parameters:
[
  46
]
22 0.22 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.data AS data_3, t0.attribute_id AS attribute_id_4 FROM features_lines t0 WHERE t0.id = ?
Parameters:
[
  2179
]
23 0.26 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.ref_distributor AS ref_distributor_3, t0.end AS end_4, t0.product_id AS product_id_5, t0.distributor_id AS distributor_id_6 FROM stock t0 WHERE t0.product_id = ?
Parameters:
[
  23606
]
24 0.33 ms
SELECT t0.id AS id_1, t0.active AS active_2, t0.first AS first_3, t0.src AS src_4, t0.product_id AS product_id_5 FROM images t0 WHERE t0.product_id = ? ORDER BY t0.first ASC
Parameters:
[
  23606
]
25 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.link AS link_4, t0.position AS position_5, t0.title AS title_6, t0.icon AS icon_7, t0.thumbnail AS thumbnail_8, t0.image AS image_9, t0.margin AS margin_10, t0.description AS description_11, t0.parent_id AS parent_id_12 FROM categories t0 INNER JOIN categories_products ON t0.id = categories_products.categories_id WHERE categories_products.products_id = ?
Parameters:
[
  23606
]
26 0.50 ms
SELECT t0.id AS id_1, t0.price_distributor AS price_distributor_2, t0.price_suggested AS price_suggested_3, t0.date_update AS date_update_4, t0.price AS price_5, t0.selected AS selected_6, t0.tvarate AS tvarate_7, t0.product_id AS product_id_8, t0.distributor_id AS distributor_id_9 FROM prices t0 WHERE t0.product_id = ? ORDER BY t0.selected ASC
Parameters:
[
  11484
]
27 0.31 ms
SELECT t0.id AS id_1, t0.date_rating AS date_rating_2, t0.recommanded AS recommanded_3, t0.facility_use AS facility_use_4, t0.quality_price AS quality_price_5, t0.design AS design_6, t0.material AS material_7, t0.pseudo AS pseudo_8, t0.email AS email_9, t0.avis AS avis_10, t0.utile_in AS utile_in_11, t0.utile_out AS utile_out_12, t0.active AS active_13, t0.rating AS rating_14, t0.validated AS validated_15, t0.product_id AS product_id_16 FROM product_rating t0 WHERE t0.product_id = ?
Parameters:
[
  11484
]
28 0.39 ms
SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.feature_line_id AS feature_line_id_3 FROM product_features t0 WHERE t0.product_id = ?
Parameters:
[
  11484
]
29 0.25 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.data AS data_3, t0.attribute_id AS attribute_id_4 FROM features_lines t0 WHERE t0.id = ?
Parameters:
[
  48
]
30 0.21 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.data AS data_3, t0.attribute_id AS attribute_id_4 FROM features_lines t0 WHERE t0.id = ?
Parameters:
[
  1745
]
31 0.48 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.ref_distributor AS ref_distributor_3, t0.end AS end_4, t0.product_id AS product_id_5, t0.distributor_id AS distributor_id_6 FROM stock t0 WHERE t0.product_id = ?
Parameters:
[
  11484
]
32 0.51 ms
SELECT t0.id AS id_1, t0.active AS active_2, t0.first AS first_3, t0.src AS src_4, t0.product_id AS product_id_5 FROM images t0 WHERE t0.product_id = ? ORDER BY t0.first ASC
Parameters:
[
  11484
]
33 0.74 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.link AS link_4, t0.position AS position_5, t0.title AS title_6, t0.icon AS icon_7, t0.thumbnail AS thumbnail_8, t0.image AS image_9, t0.margin AS margin_10, t0.description AS description_11, t0.parent_id AS parent_id_12 FROM categories t0 INNER JOIN categories_products ON t0.id = categories_products.categories_id WHERE categories_products.products_id = ?
Parameters:
[
  11484
]
34 0.46 ms
SELECT t0.id AS id_1, t0.price_distributor AS price_distributor_2, t0.price_suggested AS price_suggested_3, t0.date_update AS date_update_4, t0.price AS price_5, t0.selected AS selected_6, t0.tvarate AS tvarate_7, t0.product_id AS product_id_8, t0.distributor_id AS distributor_id_9 FROM prices t0 WHERE t0.product_id = ? ORDER BY t0.selected ASC
Parameters:
[
  4708
]
35 0.28 ms
SELECT t0.id AS id_1, t0.date_rating AS date_rating_2, t0.recommanded AS recommanded_3, t0.facility_use AS facility_use_4, t0.quality_price AS quality_price_5, t0.design AS design_6, t0.material AS material_7, t0.pseudo AS pseudo_8, t0.email AS email_9, t0.avis AS avis_10, t0.utile_in AS utile_in_11, t0.utile_out AS utile_out_12, t0.active AS active_13, t0.rating AS rating_14, t0.validated AS validated_15, t0.product_id AS product_id_16 FROM product_rating t0 WHERE t0.product_id = ?
Parameters:
[
  4708
]
36 0.39 ms
SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.feature_line_id AS feature_line_id_3 FROM product_features t0 WHERE t0.product_id = ?
Parameters:
[
  4708
]
37 0.22 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.data AS data_3, t0.attribute_id AS attribute_id_4 FROM features_lines t0 WHERE t0.id = ?
Parameters:
[
  949
]
38 0.20 ms
SELECT t0.id AS id_1, t0.feature AS feature_2 FROM features_list t0 WHERE t0.id = ?
Parameters:
[
  4
]
39 0.24 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.data AS data_3, t0.attribute_id AS attribute_id_4 FROM features_lines t0 WHERE t0.id = ?
Parameters:
[
  45
]
40 0.22 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.data AS data_3, t0.attribute_id AS attribute_id_4 FROM features_lines t0 WHERE t0.id = ?
Parameters:
[
  475
]
41 0.41 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.ref_distributor AS ref_distributor_3, t0.end AS end_4, t0.product_id AS product_id_5, t0.distributor_id AS distributor_id_6 FROM stock t0 WHERE t0.product_id = ?
Parameters:
[
  4708
]
42 0.44 ms
SELECT t0.id AS id_1, t0.active AS active_2, t0.first AS first_3, t0.src AS src_4, t0.product_id AS product_id_5 FROM images t0 WHERE t0.product_id = ? ORDER BY t0.first ASC
Parameters:
[
  4708
]
43 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.description AS description_4, t0.distributors AS distributors_5, t0.distributor_id AS distributor_id_6 FROM brand t0 WHERE t0.id = ?
Parameters:
[
  262
]
44 0.43 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.link AS link_4, t0.position AS position_5, t0.title AS title_6, t0.icon AS icon_7, t0.thumbnail AS thumbnail_8, t0.image AS image_9, t0.margin AS margin_10, t0.description AS description_11, t0.parent_id AS parent_id_12 FROM categories t0 INNER JOIN categories_products ON t0.id = categories_products.categories_id WHERE categories_products.products_id = ?
Parameters:
[
  4708
]
45 0.28 ms
SELECT t0.id AS id_1, t0.price_distributor AS price_distributor_2, t0.price_suggested AS price_suggested_3, t0.date_update AS date_update_4, t0.price AS price_5, t0.selected AS selected_6, t0.tvarate AS tvarate_7, t0.product_id AS product_id_8, t0.distributor_id AS distributor_id_9 FROM prices t0 WHERE t0.product_id = ? ORDER BY t0.selected ASC
Parameters:
[
  4710
]
46 0.26 ms
SELECT t0.id AS id_1, t0.date_rating AS date_rating_2, t0.recommanded AS recommanded_3, t0.facility_use AS facility_use_4, t0.quality_price AS quality_price_5, t0.design AS design_6, t0.material AS material_7, t0.pseudo AS pseudo_8, t0.email AS email_9, t0.avis AS avis_10, t0.utile_in AS utile_in_11, t0.utile_out AS utile_out_12, t0.active AS active_13, t0.rating AS rating_14, t0.validated AS validated_15, t0.product_id AS product_id_16 FROM product_rating t0 WHERE t0.product_id = ?
Parameters:
[
  4710
]
47 0.24 ms
SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.feature_line_id AS feature_line_id_3 FROM product_features t0 WHERE t0.product_id = ?
Parameters:
[
  4710
]
48 0.20 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.data AS data_3, t0.attribute_id AS attribute_id_4 FROM features_lines t0 WHERE t0.id = ?
Parameters:
[
  173
]
49 0.22 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.ref_distributor AS ref_distributor_3, t0.end AS end_4, t0.product_id AS product_id_5, t0.distributor_id AS distributor_id_6 FROM stock t0 WHERE t0.product_id = ?
Parameters:
[
  4710
]
50 0.27 ms
SELECT t0.id AS id_1, t0.active AS active_2, t0.first AS first_3, t0.src AS src_4, t0.product_id AS product_id_5 FROM images t0 WHERE t0.product_id = ? ORDER BY t0.first ASC
Parameters:
[
  4710
]
51 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.link AS link_4, t0.position AS position_5, t0.title AS title_6, t0.icon AS icon_7, t0.thumbnail AS thumbnail_8, t0.image AS image_9, t0.margin AS margin_10, t0.description AS description_11, t0.parent_id AS parent_id_12 FROM categories t0 INNER JOIN categories_products ON t0.id = categories_products.categories_id WHERE categories_products.products_id = ?
Parameters:
[
  4710
]
52 0.27 ms
SELECT t0.id AS id_1, t0.price_distributor AS price_distributor_2, t0.price_suggested AS price_suggested_3, t0.date_update AS date_update_4, t0.price AS price_5, t0.selected AS selected_6, t0.tvarate AS tvarate_7, t0.product_id AS product_id_8, t0.distributor_id AS distributor_id_9 FROM prices t0 WHERE t0.product_id = ? ORDER BY t0.selected ASC
Parameters:
[
  22770
]
53 0.28 ms
SELECT t0.id AS id_1, t0.date_rating AS date_rating_2, t0.recommanded AS recommanded_3, t0.facility_use AS facility_use_4, t0.quality_price AS quality_price_5, t0.design AS design_6, t0.material AS material_7, t0.pseudo AS pseudo_8, t0.email AS email_9, t0.avis AS avis_10, t0.utile_in AS utile_in_11, t0.utile_out AS utile_out_12, t0.active AS active_13, t0.rating AS rating_14, t0.validated AS validated_15, t0.product_id AS product_id_16 FROM product_rating t0 WHERE t0.product_id = ?
Parameters:
[
  22770
]
54 0.25 ms
SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.feature_line_id AS feature_line_id_3 FROM product_features t0 WHERE t0.product_id = ?
Parameters:
[
  22770
]
55 0.22 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.data AS data_3, t0.attribute_id AS attribute_id_4 FROM features_lines t0 WHERE t0.id = ?
Parameters:
[
  482
]
56 0.35 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.ref_distributor AS ref_distributor_3, t0.end AS end_4, t0.product_id AS product_id_5, t0.distributor_id AS distributor_id_6 FROM stock t0 WHERE t0.product_id = ?
Parameters:
[
  22770
]
57 0.40 ms
SELECT t0.id AS id_1, t0.active AS active_2, t0.first AS first_3, t0.src AS src_4, t0.product_id AS product_id_5 FROM images t0 WHERE t0.product_id = ? ORDER BY t0.first ASC
Parameters:
[
  22770
]
58 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.description AS description_4, t0.distributors AS distributors_5, t0.distributor_id AS distributor_id_6 FROM brand t0 WHERE t0.id = ?
Parameters:
[
  532
]
59 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.link AS link_4, t0.position AS position_5, t0.title AS title_6, t0.icon AS icon_7, t0.thumbnail AS thumbnail_8, t0.image AS image_9, t0.margin AS margin_10, t0.description AS description_11, t0.parent_id AS parent_id_12 FROM categories t0 INNER JOIN categories_products ON t0.id = categories_products.categories_id WHERE categories_products.products_id = ?
Parameters:
[
  22770
]
60 0.29 ms
SELECT t0.id AS id_1, t0.price_distributor AS price_distributor_2, t0.price_suggested AS price_suggested_3, t0.date_update AS date_update_4, t0.price AS price_5, t0.selected AS selected_6, t0.tvarate AS tvarate_7, t0.product_id AS product_id_8, t0.distributor_id AS distributor_id_9 FROM prices t0 WHERE t0.product_id = ? ORDER BY t0.selected ASC
Parameters:
[
  22940
]
61 0.27 ms
SELECT t0.id AS id_1, t0.date_rating AS date_rating_2, t0.recommanded AS recommanded_3, t0.facility_use AS facility_use_4, t0.quality_price AS quality_price_5, t0.design AS design_6, t0.material AS material_7, t0.pseudo AS pseudo_8, t0.email AS email_9, t0.avis AS avis_10, t0.utile_in AS utile_in_11, t0.utile_out AS utile_out_12, t0.active AS active_13, t0.rating AS rating_14, t0.validated AS validated_15, t0.product_id AS product_id_16 FROM product_rating t0 WHERE t0.product_id = ?
Parameters:
[
  22940
]
62 0.26 ms
SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.feature_line_id AS feature_line_id_3 FROM product_features t0 WHERE t0.product_id = ?
Parameters:
[
  22940
]
63 0.22 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.data AS data_3, t0.attribute_id AS attribute_id_4 FROM features_lines t0 WHERE t0.id = ?
Parameters:
[
  3001
]
64 0.20 ms
SELECT t0.id AS id_1, t0.feature AS feature_2 FROM features_list t0 WHERE t0.id = ?
Parameters:
[
  37
]
65 0.25 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.ref_distributor AS ref_distributor_3, t0.end AS end_4, t0.product_id AS product_id_5, t0.distributor_id AS distributor_id_6 FROM stock t0 WHERE t0.product_id = ?
Parameters:
[
  22940
]
66 0.42 ms
SELECT t0.id AS id_1, t0.active AS active_2, t0.first AS first_3, t0.src AS src_4, t0.product_id AS product_id_5 FROM images t0 WHERE t0.product_id = ? ORDER BY t0.first ASC
Parameters:
[
  22940
]
67 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.link AS link_4, t0.position AS position_5, t0.title AS title_6, t0.icon AS icon_7, t0.thumbnail AS thumbnail_8, t0.image AS image_9, t0.margin AS margin_10, t0.description AS description_11, t0.parent_id AS parent_id_12 FROM categories t0 INNER JOIN categories_products ON t0.id = categories_products.categories_id WHERE categories_products.products_id = ?
Parameters:
[
  22940
]
68 0.28 ms
SELECT t0.id AS id_1, t0.price_distributor AS price_distributor_2, t0.price_suggested AS price_suggested_3, t0.date_update AS date_update_4, t0.price AS price_5, t0.selected AS selected_6, t0.tvarate AS tvarate_7, t0.product_id AS product_id_8, t0.distributor_id AS distributor_id_9 FROM prices t0 WHERE t0.product_id = ? ORDER BY t0.selected ASC
Parameters:
[
  22938
]
69 0.30 ms
SELECT t0.id AS id_1, t0.date_rating AS date_rating_2, t0.recommanded AS recommanded_3, t0.facility_use AS facility_use_4, t0.quality_price AS quality_price_5, t0.design AS design_6, t0.material AS material_7, t0.pseudo AS pseudo_8, t0.email AS email_9, t0.avis AS avis_10, t0.utile_in AS utile_in_11, t0.utile_out AS utile_out_12, t0.active AS active_13, t0.rating AS rating_14, t0.validated AS validated_15, t0.product_id AS product_id_16 FROM product_rating t0 WHERE t0.product_id = ?
Parameters:
[
  22938
]
70 0.23 ms
SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.feature_line_id AS feature_line_id_3 FROM product_features t0 WHERE t0.product_id = ?
Parameters:
[
  22938
]
71 0.25 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.ref_distributor AS ref_distributor_3, t0.end AS end_4, t0.product_id AS product_id_5, t0.distributor_id AS distributor_id_6 FROM stock t0 WHERE t0.product_id = ?
Parameters:
[
  22938
]
72 0.25 ms
SELECT t0.id AS id_1, t0.active AS active_2, t0.first AS first_3, t0.src AS src_4, t0.product_id AS product_id_5 FROM images t0 WHERE t0.product_id = ? ORDER BY t0.first ASC
Parameters:
[
  22938
]
73 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.link AS link_4, t0.position AS position_5, t0.title AS title_6, t0.icon AS icon_7, t0.thumbnail AS thumbnail_8, t0.image AS image_9, t0.margin AS margin_10, t0.description AS description_11, t0.parent_id AS parent_id_12 FROM categories t0 INNER JOIN categories_products ON t0.id = categories_products.categories_id WHERE categories_products.products_id = ?
Parameters:
[
  22938
]
74 50.71 ms
SELECT DISTINCT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.content AS content_3, p0_.created_at AS created_at_4, p0_.active AS active_5, p0_.code_ean AS code_ean_6, p0_.last_modification AS last_modification_7, p0_.old_price AS old_price_8, p0_.promo AS promo_9, p0_.top AS top_10, p0_.weight AS weight_11, p0_.reference AS reference_12, p0_.valid AS valid_13, p0_.tvarate AS tvarate_14, p0_.brand_id AS brand_id_15 FROM products p0_ INNER JOIN stock s1_ WHERE p0_.promo = 1 AND s1_.product_id = p0_.id AND p0_.active = 1 AND p0_.valid = 1 AND s1_.quantity > 0 GROUP BY p0_.reference ORDER BY p0_.last_modification DESC, p0_.name ASC LIMIT 8
Parameters:
[]
75 0.46 ms
SELECT t0.id AS id_1, t0.price_distributor AS price_distributor_2, t0.price_suggested AS price_suggested_3, t0.date_update AS date_update_4, t0.price AS price_5, t0.selected AS selected_6, t0.tvarate AS tvarate_7, t0.product_id AS product_id_8, t0.distributor_id AS distributor_id_9 FROM prices t0 WHERE t0.product_id = ? ORDER BY t0.selected ASC
Parameters:
[
  22759
]
76 0.33 ms
SELECT t0.id AS id_1, t0.date_rating AS date_rating_2, t0.recommanded AS recommanded_3, t0.facility_use AS facility_use_4, t0.quality_price AS quality_price_5, t0.design AS design_6, t0.material AS material_7, t0.pseudo AS pseudo_8, t0.email AS email_9, t0.avis AS avis_10, t0.utile_in AS utile_in_11, t0.utile_out AS utile_out_12, t0.active AS active_13, t0.rating AS rating_14, t0.validated AS validated_15, t0.product_id AS product_id_16 FROM product_rating t0 WHERE t0.product_id = ?
Parameters:
[
  22759
]
77 0.26 ms
SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.feature_line_id AS feature_line_id_3 FROM product_features t0 WHERE t0.product_id = ?
Parameters:
[
  22759
]
78 0.26 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.ref_distributor AS ref_distributor_3, t0.end AS end_4, t0.product_id AS product_id_5, t0.distributor_id AS distributor_id_6 FROM stock t0 WHERE t0.product_id = ?
Parameters:
[
  22759
]
79 0.32 ms
SELECT t0.id AS id_1, t0.active AS active_2, t0.first AS first_3, t0.src AS src_4, t0.product_id AS product_id_5 FROM images t0 WHERE t0.product_id = ? ORDER BY t0.first ASC
Parameters:
[
  22759
]
80 0.52 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.link AS link_4, t0.position AS position_5, t0.title AS title_6, t0.icon AS icon_7, t0.thumbnail AS thumbnail_8, t0.image AS image_9, t0.margin AS margin_10, t0.description AS description_11, t0.parent_id AS parent_id_12 FROM categories t0 INNER JOIN categories_products ON t0.id = categories_products.categories_id WHERE categories_products.products_id = ?
Parameters:
[
  22759
]
81 0.49 ms
SELECT t0.id AS id_1, t0.price_distributor AS price_distributor_2, t0.price_suggested AS price_suggested_3, t0.date_update AS date_update_4, t0.price AS price_5, t0.selected AS selected_6, t0.tvarate AS tvarate_7, t0.product_id AS product_id_8, t0.distributor_id AS distributor_id_9 FROM prices t0 WHERE t0.product_id = ? ORDER BY t0.selected ASC
Parameters:
[
  1501
]
82 0.31 ms
SELECT t0.id AS id_1, t0.date_rating AS date_rating_2, t0.recommanded AS recommanded_3, t0.facility_use AS facility_use_4, t0.quality_price AS quality_price_5, t0.design AS design_6, t0.material AS material_7, t0.pseudo AS pseudo_8, t0.email AS email_9, t0.avis AS avis_10, t0.utile_in AS utile_in_11, t0.utile_out AS utile_out_12, t0.active AS active_13, t0.rating AS rating_14, t0.validated AS validated_15, t0.product_id AS product_id_16 FROM product_rating t0 WHERE t0.product_id = ?
Parameters:
[
  1501
]
83 0.39 ms
SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.feature_line_id AS feature_line_id_3 FROM product_features t0 WHERE t0.product_id = ?
Parameters:
[
  1501
]
84 0.23 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.data AS data_3, t0.attribute_id AS attribute_id_4 FROM features_lines t0 WHERE t0.id = ?
Parameters:
[
  414
]
85 0.20 ms
SELECT t0.id AS id_1, t0.feature AS feature_2 FROM features_list t0 WHERE t0.id = ?
Parameters:
[
  17
]
86 0.20 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.data AS data_3, t0.attribute_id AS attribute_id_4 FROM features_lines t0 WHERE t0.id = ?
Parameters:
[
  1726
]
87 0.20 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.data AS data_3, t0.attribute_id AS attribute_id_4 FROM features_lines t0 WHERE t0.id = ?
Parameters:
[
  1652
]
88 0.20 ms
SELECT t0.id AS id_1, t0.feature AS feature_2 FROM features_list t0 WHERE t0.id = ?
Parameters:
[
  38
]
89 0.41 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.ref_distributor AS ref_distributor_3, t0.end AS end_4, t0.product_id AS product_id_5, t0.distributor_id AS distributor_id_6 FROM stock t0 WHERE t0.product_id = ?
Parameters:
[
  1501
]
90 0.57 ms
SELECT t0.id AS id_1, t0.active AS active_2, t0.first AS first_3, t0.src AS src_4, t0.product_id AS product_id_5 FROM images t0 WHERE t0.product_id = ? ORDER BY t0.first ASC
Parameters:
[
  1501
]
91 0.44 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.link AS link_4, t0.position AS position_5, t0.title AS title_6, t0.icon AS icon_7, t0.thumbnail AS thumbnail_8, t0.image AS image_9, t0.margin AS margin_10, t0.description AS description_11, t0.parent_id AS parent_id_12 FROM categories t0 INNER JOIN categories_products ON t0.id = categories_products.categories_id WHERE categories_products.products_id = ?
Parameters:
[
  1501
]
92 0.29 ms
SELECT t0.id AS id_1, t0.price_distributor AS price_distributor_2, t0.price_suggested AS price_suggested_3, t0.date_update AS date_update_4, t0.price AS price_5, t0.selected AS selected_6, t0.tvarate AS tvarate_7, t0.product_id AS product_id_8, t0.distributor_id AS distributor_id_9 FROM prices t0 WHERE t0.product_id = ? ORDER BY t0.selected ASC
Parameters:
[
  916
]
93 0.24 ms
SELECT t0.id AS id_1, t0.date_rating AS date_rating_2, t0.recommanded AS recommanded_3, t0.facility_use AS facility_use_4, t0.quality_price AS quality_price_5, t0.design AS design_6, t0.material AS material_7, t0.pseudo AS pseudo_8, t0.email AS email_9, t0.avis AS avis_10, t0.utile_in AS utile_in_11, t0.utile_out AS utile_out_12, t0.active AS active_13, t0.rating AS rating_14, t0.validated AS validated_15, t0.product_id AS product_id_16 FROM product_rating t0 WHERE t0.product_id = ?
Parameters:
[
  916
]
94 0.22 ms
SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.feature_line_id AS feature_line_id_3 FROM product_features t0 WHERE t0.product_id = ?
Parameters:
[
  916
]
95 0.19 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.data AS data_3, t0.attribute_id AS attribute_id_4 FROM features_lines t0 WHERE t0.id = ?
Parameters:
[
  529
]
96 0.22 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.ref_distributor AS ref_distributor_3, t0.end AS end_4, t0.product_id AS product_id_5, t0.distributor_id AS distributor_id_6 FROM stock t0 WHERE t0.product_id = ?
Parameters:
[
  916
]
97 0.38 ms
SELECT t0.id AS id_1, t0.active AS active_2, t0.first AS first_3, t0.src AS src_4, t0.product_id AS product_id_5 FROM images t0 WHERE t0.product_id = ? ORDER BY t0.first ASC
Parameters:
[
  916
]
98 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.description AS description_4, t0.distributors AS distributors_5, t0.distributor_id AS distributor_id_6 FROM brand t0 WHERE t0.id = ?
Parameters:
[
  34
]
99 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.link AS link_4, t0.position AS position_5, t0.title AS title_6, t0.icon AS icon_7, t0.thumbnail AS thumbnail_8, t0.image AS image_9, t0.margin AS margin_10, t0.description AS description_11, t0.parent_id AS parent_id_12 FROM categories t0 INNER JOIN categories_products ON t0.id = categories_products.categories_id WHERE categories_products.products_id = ?
Parameters:
[
  916
]
100 0.39 ms
SELECT t0.id AS id_1, t0.price_distributor AS price_distributor_2, t0.price_suggested AS price_suggested_3, t0.date_update AS date_update_4, t0.price AS price_5, t0.selected AS selected_6, t0.tvarate AS tvarate_7, t0.product_id AS product_id_8, t0.distributor_id AS distributor_id_9 FROM prices t0 WHERE t0.product_id = ? ORDER BY t0.selected ASC
Parameters:
[
  2545
]
101 0.24 ms
SELECT t0.id AS id_1, t0.date_rating AS date_rating_2, t0.recommanded AS recommanded_3, t0.facility_use AS facility_use_4, t0.quality_price AS quality_price_5, t0.design AS design_6, t0.material AS material_7, t0.pseudo AS pseudo_8, t0.email AS email_9, t0.avis AS avis_10, t0.utile_in AS utile_in_11, t0.utile_out AS utile_out_12, t0.active AS active_13, t0.rating AS rating_14, t0.validated AS validated_15, t0.product_id AS product_id_16 FROM product_rating t0 WHERE t0.product_id = ?
Parameters:
[
  2545
]
102 0.36 ms
SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.feature_line_id AS feature_line_id_3 FROM product_features t0 WHERE t0.product_id = ?
Parameters:
[
  2545
]
103 0.20 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.data AS data_3, t0.attribute_id AS attribute_id_4 FROM features_lines t0 WHERE t0.id = ?
Parameters:
[
  102
]
104 0.18 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.data AS data_3, t0.attribute_id AS attribute_id_4 FROM features_lines t0 WHERE t0.id = ?
Parameters:
[
  1448
]
105 0.34 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.ref_distributor AS ref_distributor_3, t0.end AS end_4, t0.product_id AS product_id_5, t0.distributor_id AS distributor_id_6 FROM stock t0 WHERE t0.product_id = ?
Parameters:
[
  2545
]
106 0.39 ms
SELECT t0.id AS id_1, t0.active AS active_2, t0.first AS first_3, t0.src AS src_4, t0.product_id AS product_id_5 FROM images t0 WHERE t0.product_id = ? ORDER BY t0.first ASC
Parameters:
[
  2545
]
107 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.description AS description_4, t0.distributors AS distributors_5, t0.distributor_id AS distributor_id_6 FROM brand t0 WHERE t0.id = ?
Parameters:
[
  31
]
108 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.link AS link_4, t0.position AS position_5, t0.title AS title_6, t0.icon AS icon_7, t0.thumbnail AS thumbnail_8, t0.image AS image_9, t0.margin AS margin_10, t0.description AS description_11, t0.parent_id AS parent_id_12 FROM categories t0 INNER JOIN categories_products ON t0.id = categories_products.categories_id WHERE categories_products.products_id = ?
Parameters:
[
  2545
]
109 0.28 ms
SELECT t0.id AS id_1, t0.price_distributor AS price_distributor_2, t0.price_suggested AS price_suggested_3, t0.date_update AS date_update_4, t0.price AS price_5, t0.selected AS selected_6, t0.tvarate AS tvarate_7, t0.product_id AS product_id_8, t0.distributor_id AS distributor_id_9 FROM prices t0 WHERE t0.product_id = ? ORDER BY t0.selected ASC
Parameters:
[
  663
]
110 0.24 ms
SELECT t0.id AS id_1, t0.date_rating AS date_rating_2, t0.recommanded AS recommanded_3, t0.facility_use AS facility_use_4, t0.quality_price AS quality_price_5, t0.design AS design_6, t0.material AS material_7, t0.pseudo AS pseudo_8, t0.email AS email_9, t0.avis AS avis_10, t0.utile_in AS utile_in_11, t0.utile_out AS utile_out_12, t0.active AS active_13, t0.rating AS rating_14, t0.validated AS validated_15, t0.product_id AS product_id_16 FROM product_rating t0 WHERE t0.product_id = ?
Parameters:
[
  663
]
111 0.22 ms
SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.feature_line_id AS feature_line_id_3 FROM product_features t0 WHERE t0.product_id = ?
Parameters:
[
  663
]
112 0.24 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.data AS data_3, t0.attribute_id AS attribute_id_4 FROM features_lines t0 WHERE t0.id = ?
Parameters:
[
  51
]
113 0.22 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.ref_distributor AS ref_distributor_3, t0.end AS end_4, t0.product_id AS product_id_5, t0.distributor_id AS distributor_id_6 FROM stock t0 WHERE t0.product_id = ?
Parameters:
[
  663
]
114 0.40 ms
SELECT t0.id AS id_1, t0.active AS active_2, t0.first AS first_3, t0.src AS src_4, t0.product_id AS product_id_5 FROM images t0 WHERE t0.product_id = ? ORDER BY t0.first ASC
Parameters:
[
  663
]
115 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.link AS link_4, t0.position AS position_5, t0.title AS title_6, t0.icon AS icon_7, t0.thumbnail AS thumbnail_8, t0.image AS image_9, t0.margin AS margin_10, t0.description AS description_11, t0.parent_id AS parent_id_12 FROM categories t0 INNER JOIN categories_products ON t0.id = categories_products.categories_id WHERE categories_products.products_id = ?
Parameters:
[
  663
]
116 0.38 ms
SELECT t0.id AS id_1, t0.date_rating AS date_rating_2, t0.recommanded AS recommanded_3, t0.facility_use AS facility_use_4, t0.quality_price AS quality_price_5, t0.design AS design_6, t0.material AS material_7, t0.pseudo AS pseudo_8, t0.email AS email_9, t0.avis AS avis_10, t0.utile_in AS utile_in_11, t0.utile_out AS utile_out_12, t0.active AS active_13, t0.rating AS rating_14, t0.validated AS validated_15, t0.product_id AS product_id_16 FROM product_rating t0
Parameters:
[]
117 0.46 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.content AS content_4, t0.created_at AS created_at_5, t0.active AS active_6, t0.code_ean AS code_ean_7, t0.last_modification AS last_modification_8, t0.old_price AS old_price_9, t0.promo AS promo_10, t0.top AS top_11, t0.weight AS weight_12, t0.reference AS reference_13, t0.valid AS valid_14, t0.tvarate AS tvarate_15, t0.brand_id AS brand_id_16 FROM products t0 WHERE t0.id = ?
Parameters:
[
  1
]
118 0.40 ms
SELECT t0.id AS id_1, t0.active AS active_2, t0.first AS first_3, t0.src AS src_4, t0.product_id AS product_id_5 FROM images t0 WHERE t0.product_id = ? ORDER BY t0.first ASC
Parameters:
[
  1
]
119 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.content AS content_4, t0.created_at AS created_at_5, t0.active AS active_6, t0.code_ean AS code_ean_7, t0.last_modification AS last_modification_8, t0.old_price AS old_price_9, t0.promo AS promo_10, t0.top AS top_11, t0.weight AS weight_12, t0.reference AS reference_13, t0.valid AS valid_14, t0.tvarate AS tvarate_15, t0.brand_id AS brand_id_16 FROM products t0 WHERE t0.id = ?
Parameters:
[
  11847
]
120 0.59 ms
SELECT t0.id AS id_1, t0.active AS active_2, t0.first AS first_3, t0.src AS src_4, t0.product_id AS product_id_5 FROM images t0 WHERE t0.product_id = ? ORDER BY t0.first ASC
Parameters:
[
  11847
]
121 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.content AS content_4, t0.created_at AS created_at_5, t0.active AS active_6, t0.code_ean AS code_ean_7, t0.last_modification AS last_modification_8, t0.old_price AS old_price_9, t0.promo AS promo_10, t0.top AS top_11, t0.weight AS weight_12, t0.reference AS reference_13, t0.valid AS valid_14, t0.tvarate AS tvarate_15, t0.brand_id AS brand_id_16 FROM products t0 WHERE t0.id = ?
Parameters:
[
  725
]
122 0.37 ms
SELECT t0.id AS id_1, t0.active AS active_2, t0.first AS first_3, t0.src AS src_4, t0.product_id AS product_id_5 FROM images t0 WHERE t0.product_id = ? ORDER BY t0.first ASC
Parameters:
[
  725
]
123 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.content AS content_4, t0.created_at AS created_at_5, t0.active AS active_6, t0.code_ean AS code_ean_7, t0.last_modification AS last_modification_8, t0.old_price AS old_price_9, t0.promo AS promo_10, t0.top AS top_11, t0.weight AS weight_12, t0.reference AS reference_13, t0.valid AS valid_14, t0.tvarate AS tvarate_15, t0.brand_id AS brand_id_16 FROM products t0 WHERE t0.id = ?
Parameters:
[
  2675
]
124 0.63 ms
SELECT t0.id AS id_1, t0.active AS active_2, t0.first AS first_3, t0.src AS src_4, t0.product_id AS product_id_5 FROM images t0 WHERE t0.product_id = ? ORDER BY t0.first ASC
Parameters:
[
  2675
]
125 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.content AS content_4, t0.created_at AS created_at_5, t0.active AS active_6, t0.code_ean AS code_ean_7, t0.last_modification AS last_modification_8, t0.old_price AS old_price_9, t0.promo AS promo_10, t0.top AS top_11, t0.weight AS weight_12, t0.reference AS reference_13, t0.valid AS valid_14, t0.tvarate AS tvarate_15, t0.brand_id AS brand_id_16 FROM products t0 WHERE t0.id = ?
Parameters:
[
  25123
]
126 0.39 ms
SELECT t0.id AS id_1, t0.active AS active_2, t0.first AS first_3, t0.src AS src_4, t0.product_id AS product_id_5 FROM images t0 WHERE t0.product_id = ? ORDER BY t0.first ASC
Parameters:
[
  25123
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Images 67
App\Entity\ProductFeatures 40
App\Entity\FeaturesLines 21
App\Entity\Prices 20
App\Entity\Stock 20
App\Entity\Products 18
App\Entity\Categories 15
App\Entity\Brand 9
App\Entity\FeaturesList 8
App\Entity\ProductRating 6
App\Entity\Distributor 3