Symfony Profiler

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 = ?

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 = 23372;

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

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 = 23372 ORDER BY t0.first ASC;

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 = ?

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 = 23372;

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 = ?

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 = 191;

SELECT
  t0.id AS id_1,
  t0.feature AS feature_2
FROM
  features_list t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.feature AS feature_2 FROM features_list t0 WHERE t0.id = 4;

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 = ?

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 = 45;

SELECT
  t0.id AS id_1,
  t0.feature AS feature_2
FROM
  features_list t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.feature AS feature_2 FROM features_list t0 WHERE t0.id = 2;

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 = ?

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 = 1710;

SELECT
  t0.id AS id_1,
  t0.feature AS feature_2
FROM
  features_list t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.feature AS feature_2 FROM features_list t0 WHERE t0.id = 3;

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

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 = 23372 ORDER BY t0.selected ASC;

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 = ?

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 = 23372;

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

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 >= 100 AND c1_.id = s0_.carrier_id AND c1_.actif = 1 AND s0_.distributor_id IN ('3') GROUP BY s0_.carrier_id ORDER BY s0_.shipping_cost ASC;

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 = ?

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 = 23372;

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 = ?

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 = 'BC023372';

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 = ?

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 = 23372;

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 = ?

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 = 3;

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 = ?

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 = 23372;

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 = ?

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 = 'BC023372';

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

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 >= 100 AND c1_.id = s0_.carrier_id AND c1_.actif = 1 AND s0_.distributor_id IN ('3') GROUP BY s0_.carrier_id ORDER BY s0_.shipping_cost ASC;

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 = ?

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 = 23372;

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 = ?

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 = 'BC023372';

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 = ?

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 = 23372;

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 = ?

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 = 23372;

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 = ?

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 = 262;

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 = ?

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 = 'BC023372';

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

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 >= 100 AND c1_.id = s0_.carrier_id AND c1_.actif = 1 AND s0_.distributor_id IN ('3') GROUP BY s0_.carrier_id ORDER BY s0_.shipping_cost ASC;

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 = ?

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 = 23372;

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 = ?

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 = 'BC023372';

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 = ?

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 = 23372;

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

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 = 'Noir' AND t0.first = 1 LIMIT 1;