Symfony Profiler

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

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;

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

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;

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

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

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

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

SELECT
  *
FROM
  brand as b
WHERE
  (
    b.logo IS NOT NULL
    AND b.logo <> ''
  )
ORDER BY
  RAND()
LIMIT
  25

SELECT * FROM brand as b WHERE (b.logo IS NOT NULL AND b.logo <> '') ORDER BY RAND() LIMIT 25;

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

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

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.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 = 1;

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

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

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;