GET https://boutiquecoquinage.fr/robe-fendue-queen-size-f268-noire-noir-handmade-p-22373

Query Metrics

100 Database Queries
16 Different statements
560.35 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.42 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:
[
  22373
]
2 0.46 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:
[
  22373
]
3 0.31 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:
[
  22373
]
4 0.30 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:
[
  88
]
5 0.24 ms
SELECT t0.id AS id_1, t0.feature AS feature_2 FROM features_list t0 WHERE t0.id = ?
Parameters:
[
  4
]
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:
[
  45
]
7 0.20 ms
SELECT t0.id AS id_1, t0.feature AS feature_2 FROM features_list t0 WHERE t0.id = ?
Parameters:
[
  2
]
8 0.40 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:
[
  22373
]
9 0.30 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:
[
  22373
]
10 0.75 ms
SELECT s0_.id AS id_0, s0_.weight AS weight_1, s0_.shipping_cost AS shipping_cost_2, s0_.carrier_id AS carrier_id_3, s0_.country_id AS country_id_4, s0_.distributor_id AS distributor_id_5 FROM shipping s0_, carriers c1_ WHERE s0_.country_id = 75 AND s0_.weight >= ? AND c1_.id = s0_.carrier_id AND c1_.actif = 1 AND s0_.distributor_id IN (?) GROUP BY s0_.carrier_id ORDER BY s0_.shipping_cost ASC
Parameters:
[
  690
  "1"
]
11 0.32 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 = ?
Parameters:
[
  22373
]
12 0.35 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.reference = ?
Parameters:
[
  "BC022373"
]
13 0.24 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:
[
  22373
]
14 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url_ftp AS url_ftp_3, t0.api_log AS api_log_4, t0.api_key AS api_key_5, t0.address AS address_6, t0.zipcode AS zipcode_7, t0.city AS city_8, t0.timeslot AS timeslot_9, t0.tel AS tel_10, t0.email AS email_11, t0.help AS help_12, t0.logo AS logo_13, t0.site AS site_14, t0.user_ftp AS user_ftp_15, t0.password_ftp AS password_ftp_16 FROM distributor t0 WHERE t0.id = ?
Parameters:
[
  1
]
15 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:
[
  22374
]
16 0.21 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:
[
  22375
]
17 0.23 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:
[
  22376
]
18 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:
[
  22373
]
19 288.11 ms
SELECT 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 p1_, products p0_ WHERE p0_.reference = ?
Parameters:
[
  "BC022373"
]
20 0.56 ms
SELECT s0_.id AS id_0, s0_.weight AS weight_1, s0_.shipping_cost AS shipping_cost_2, s0_.carrier_id AS carrier_id_3, s0_.country_id AS country_id_4, s0_.distributor_id AS distributor_id_5 FROM shipping s0_, carriers c1_ WHERE s0_.country_id = 75 AND s0_.weight >= ? AND c1_.id = s0_.carrier_id AND c1_.actif = 1 AND s0_.distributor_id IN (?) GROUP BY s0_.carrier_id ORDER BY s0_.shipping_cost ASC
Parameters:
[
  690
  "1"
]
21 0.25 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 = ?
Parameters:
[
  22373
]
22 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.reference = ?
Parameters:
[
  "BC022373"
]
23 0.19 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:
[
  22373
]
24 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:
[
  22374
]
25 0.19 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:
[
  22375
]
26 0.18 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:
[
  22376
]
27 0.26 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:
[
  22373
]
28 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:
[
  31
]
29 0.29 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:
[
  22374
]
30 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:
[
  22374
]
31 0.16 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:
[
  94
]
32 0.20 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:
[
  22374
]
33 0.16 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:
[
  22374
]
34 0.37 ms
SELECT s0_.id AS id_0, s0_.weight AS weight_1, s0_.shipping_cost AS shipping_cost_2, s0_.carrier_id AS carrier_id_3, s0_.country_id AS country_id_4, s0_.distributor_id AS distributor_id_5 FROM shipping s0_, carriers c1_ WHERE s0_.country_id = 75 AND s0_.weight >= ? AND c1_.id = s0_.carrier_id AND c1_.actif = 1 AND s0_.distributor_id IN (?) GROUP BY s0_.carrier_id ORDER BY s0_.shipping_cost ASC
Parameters:
[
  690
  "1"
]
35 0.19 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 = ?
Parameters:
[
  22374
]
36 0.26 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.reference = ?
Parameters:
[
  "BC022373"
]
37 0.17 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:
[
  22373
]
38 0.15 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:
[
  22374
]
39 0.16 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:
[
  22375
]
40 0.18 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:
[
  22376
]
41 0.21 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:
[
  22374
]
42 0.25 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:
[
  22374
]
43 0.22 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:
[
  22375
]
44 0.16 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:
[
  22375
]
45 0.13 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:
[
  108
]
46 0.18 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:
[
  22375
]
47 0.15 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:
[
  22375
]
48 0.30 ms
SELECT s0_.id AS id_0, s0_.weight AS weight_1, s0_.shipping_cost AS shipping_cost_2, s0_.carrier_id AS carrier_id_3, s0_.country_id AS country_id_4, s0_.distributor_id AS distributor_id_5 FROM shipping s0_, carriers c1_ WHERE s0_.country_id = 75 AND s0_.weight >= ? AND c1_.id = s0_.carrier_id AND c1_.actif = 1 AND s0_.distributor_id IN (?) GROUP BY s0_.carrier_id ORDER BY s0_.shipping_cost ASC
Parameters:
[
  690
  "1"
]
49 0.18 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 = ?
Parameters:
[
  22375
]
50 0.22 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.reference = ?
Parameters:
[
  "BC022373"
]
51 0.17 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:
[
  22373
]
52 0.15 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:
[
  22374
]
53 0.17 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:
[
  22375
]
54 0.15 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:
[
  22376
]
55 0.16 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:
[
  22375
]
56 0.20 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:
[
  22375
]
57 0.19 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:
[
  22376
]
58 0.15 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:
[
  22376
]
59 0.13 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:
[
  2460
]
60 0.18 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:
[
  22376
]
61 0.16 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:
[
  22376
]
62 0.29 ms
SELECT s0_.id AS id_0, s0_.weight AS weight_1, s0_.shipping_cost AS shipping_cost_2, s0_.carrier_id AS carrier_id_3, s0_.country_id AS country_id_4, s0_.distributor_id AS distributor_id_5 FROM shipping s0_, carriers c1_ WHERE s0_.country_id = 75 AND s0_.weight >= ? AND c1_.id = s0_.carrier_id AND c1_.actif = 1 AND s0_.distributor_id IN (?) GROUP BY s0_.carrier_id ORDER BY s0_.shipping_cost ASC
Parameters:
[
  690
  "1"
]
63 0.17 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 = ?
Parameters:
[
  22376
]
64 0.21 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.reference = ?
Parameters:
[
  "BC022373"
]
65 0.15 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:
[
  22373
]
66 0.14 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:
[
  22374
]
67 0.14 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:
[
  22375
]
68 0.15 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:
[
  22376
]
69 0.16 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:
[
  22376
]
70 0.19 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:
[
  22376
]
71 249.08 ms
SELECT 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 p1_, products p0_ WHERE p0_.reference = ?
Parameters:
[
  "BC022373"
]
72 0.67 ms
SELECT s0_.id AS id_0, s0_.weight AS weight_1, s0_.shipping_cost AS shipping_cost_2, s0_.carrier_id AS carrier_id_3, s0_.country_id AS country_id_4, s0_.distributor_id AS distributor_id_5 FROM shipping s0_, carriers c1_ WHERE s0_.country_id = 75 AND s0_.weight >= ? AND c1_.id = s0_.carrier_id AND c1_.actif = 1 AND s0_.distributor_id IN (?) GROUP BY s0_.carrier_id ORDER BY s0_.shipping_cost ASC
Parameters:
[
  690
  "1"
]
73 0.25 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 = ?
Parameters:
[
  22373
]
74 0.31 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.reference = ?
Parameters:
[
  "BC022373"
]
75 0.27 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:
[
  22373
]
76 0.20 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:
[
  22374
]
77 0.18 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:
[
  22375
]
78 0.17 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:
[
  22376
]
79 0.46 ms
SELECT s0_.id AS id_0, s0_.weight AS weight_1, s0_.shipping_cost AS shipping_cost_2, s0_.carrier_id AS carrier_id_3, s0_.country_id AS country_id_4, s0_.distributor_id AS distributor_id_5 FROM shipping s0_, carriers c1_ WHERE s0_.country_id = 75 AND s0_.weight >= ? AND c1_.id = s0_.carrier_id AND c1_.actif = 1 AND s0_.distributor_id IN (?) GROUP BY s0_.carrier_id ORDER BY s0_.shipping_cost ASC
Parameters:
[
  690
  "1"
]
80 0.22 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 = ?
Parameters:
[
  22374
]
81 0.29 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.reference = ?
Parameters:
[
  "BC022373"
]
82 0.19 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:
[
  22373
]
83 0.19 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:
[
  22374
]
84 0.19 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:
[
  22375
]
85 0.17 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:
[
  22376
]
86 0.40 ms
SELECT s0_.id AS id_0, s0_.weight AS weight_1, s0_.shipping_cost AS shipping_cost_2, s0_.carrier_id AS carrier_id_3, s0_.country_id AS country_id_4, s0_.distributor_id AS distributor_id_5 FROM shipping s0_, carriers c1_ WHERE s0_.country_id = 75 AND s0_.weight >= ? AND c1_.id = s0_.carrier_id AND c1_.actif = 1 AND s0_.distributor_id IN (?) GROUP BY s0_.carrier_id ORDER BY s0_.shipping_cost ASC
Parameters:
[
  690
  "1"
]
87 0.20 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 = ?
Parameters:
[
  22375
]
88 0.29 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.reference = ?
Parameters:
[
  "BC022373"
]
89 0.17 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:
[
  22373
]
90 0.18 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:
[
  22374
]
91 0.17 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:
[
  22375
]
92 0.16 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:
[
  22376
]
93 0.40 ms
SELECT s0_.id AS id_0, s0_.weight AS weight_1, s0_.shipping_cost AS shipping_cost_2, s0_.carrier_id AS carrier_id_3, s0_.country_id AS country_id_4, s0_.distributor_id AS distributor_id_5 FROM shipping s0_, carriers c1_ WHERE s0_.country_id = 75 AND s0_.weight >= ? AND c1_.id = s0_.carrier_id AND c1_.actif = 1 AND s0_.distributor_id IN (?) GROUP BY s0_.carrier_id ORDER BY s0_.shipping_cost ASC
Parameters:
[
  690
  "1"
]
94 0.20 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 = ?
Parameters:
[
  22376
]
95 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.reference = ?
Parameters:
[
  "BC022373"
]
96 0.21 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:
[
  22373
]
97 0.20 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:
[
  22374
]
98 0.17 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:
[
  22375
]
99 0.16 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:
[
  22376
]
100 0.21 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 = ? AND t0.first = ? LIMIT 1
Parameters:
[
  "Noir"
  1
]

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.