Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.image AS image_4,
  t0.active AS active_5,
  t0.position AS position_6,
  t0.meta_title AS meta_title_7,
  t0.meta_description AS meta_description_8,
  t0.meta_keywords AS meta_keywords_9,
  t0.parent_id AS parent_id_10
FROM
  category t0
WHERE
  t0.slug = ?
ORDER BY
  t0.id ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.active AS active_5, t0.position AS position_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.meta_keywords AS meta_keywords_9, t0.parent_id AS parent_id_10 FROM category t0 WHERE t0.slug = 'lacoste' ORDER BY t0.id ASC LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.cod AS cod_1,
  p0_.reference AS reference_2,
  p0_.name AS name_3,
  p0_.description AS description_4,
  p0_.slug AS slug_5,
  p0_.stock AS stock_6,
  p0_.pvp AS pvp_7,
  p0_.discount AS discount_8,
  p0_.net_price AS net_price_9,
  p0_.extra AS extra_10,
  p0_.images AS images_11,
  p0_.created_at AS created_at_12,
  p0_.updated_at AS updated_at_13,
  p0_.views AS views_14,
  p0_.position AS position_15,
  p0_.active AS active_16,
  p0_.meta_title AS meta_title_17,
  p0_.meta_description AS meta_description_18,
  p0_.meta_keywords AS meta_keywords_19,
  p0_.brand_id AS brand_id_20
FROM
  product p0_
  INNER JOIN product_category p2_ ON p0_.id = p2_.product_id
  INNER JOIN category c1_ ON c1_.id = p2_.category_id
WHERE
  p0_.active = ?
  AND p0_.images IS NOT NULL
  AND p0_.images <> '[]'
  AND c1_.id = ?
ORDER BY
  p0_.position ASC,
  p0_.views DESC
LIMIT
  12

SELECT p0_.id AS id_0, p0_.cod AS cod_1, p0_.reference AS reference_2, p0_.name AS name_3, p0_.description AS description_4, p0_.slug AS slug_5, p0_.stock AS stock_6, p0_.pvp AS pvp_7, p0_.discount AS discount_8, p0_.net_price AS net_price_9, p0_.extra AS extra_10, p0_.images AS images_11, p0_.created_at AS created_at_12, p0_.updated_at AS updated_at_13, p0_.views AS views_14, p0_.position AS position_15, p0_.active AS active_16, p0_.meta_title AS meta_title_17, p0_.meta_description AS meta_description_18, p0_.meta_keywords AS meta_keywords_19, p0_.brand_id AS brand_id_20 FROM product p0_ INNER JOIN product_category p2_ ON p0_.id = p2_.product_id INNER JOIN category c1_ ON c1_.id = p2_.category_id WHERE p0_.active = 1 AND p0_.images IS NOT NULL AND p0_.images <> '[]' AND c1_.id = 67 ORDER BY p0_.position ASC, p0_.views DESC LIMIT 12;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.image AS image_3,
  c0_.active AS active_4,
  c0_.position AS position_5,
  c0_.meta_title AS meta_title_6,
  c0_.meta_description AS meta_description_7,
  c0_.meta_keywords AS meta_keywords_8,
  COUNT(p1_.id) AS sclr_9,
  c0_.parent_id AS parent_id_10
FROM
  category c0_
  LEFT JOIN product_category p2_ ON c0_.id = p2_.category_id
  LEFT JOIN product p1_ ON p1_.id = p2_.product_id
WHERE
  c0_.active = ?
  AND c0_.parent_id = ?
GROUP BY
  c0_.id
ORDER BY
  c0_.position ASC,
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.image AS image_3, c0_.active AS active_4, c0_.position AS position_5, c0_.meta_title AS meta_title_6, c0_.meta_description AS meta_description_7, c0_.meta_keywords AS meta_keywords_8, COUNT(p1_.id) AS sclr_9, c0_.parent_id AS parent_id_10 FROM category c0_ LEFT JOIN product_category p2_ ON c0_.id = p2_.category_id LEFT JOIN product p1_ ON p1_.id = p2_.product_id WHERE c0_.active = 1 AND c0_.parent_id = 67 GROUP BY c0_.id ORDER BY c0_.position ASC, c0_.name ASC;

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.slug AS slug_2,
  b0_.position AS position_3,
  COUNT(p1_.id) AS sclr_4
FROM
  brand b0_
  LEFT JOIN product p1_ ON b0_.id = p1_.brand_id
GROUP BY
  b0_.id
ORDER BY
  b0_.position ASC,
  b0_.name ASC

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.slug AS slug_2, b0_.position AS position_3, COUNT(p1_.id) AS sclr_4 FROM brand b0_ LEFT JOIN product p1_ ON b0_.id = p1_.brand_id GROUP BY b0_.id ORDER BY b0_.position ASC, b0_.name ASC;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.image AS image_3,
  c0_.active AS active_4,
  c0_.position AS position_5,
  c0_.meta_title AS meta_title_6,
  c0_.meta_description AS meta_description_7,
  c0_.meta_keywords AS meta_keywords_8,
  COUNT(p1_.id) AS sclr_9,
  c0_.parent_id AS parent_id_10
FROM
  category c0_
  LEFT JOIN product_category p2_ ON c0_.id = p2_.category_id
  LEFT JOIN product p1_ ON p1_.id = p2_.product_id
WHERE
  c0_.active = ?
  AND c0_.parent_id IS NULL
GROUP BY
  c0_.id
ORDER BY
  c0_.position ASC,
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.image AS image_3, c0_.active AS active_4, c0_.position AS position_5, c0_.meta_title AS meta_title_6, c0_.meta_description AS meta_description_7, c0_.meta_keywords AS meta_keywords_8, COUNT(p1_.id) AS sclr_9, c0_.parent_id AS parent_id_10 FROM category c0_ LEFT JOIN product_category p2_ ON c0_.id = p2_.category_id LEFT JOIN product p1_ ON p1_.id = p2_.product_id WHERE c0_.active = 1 AND c0_.parent_id IS NULL GROUP BY c0_.id ORDER BY c0_.position ASC, c0_.name ASC;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.image AS image_3,
  c0_.active AS active_4,
  c0_.position AS position_5,
  c0_.meta_title AS meta_title_6,
  c0_.meta_description AS meta_description_7,
  c0_.meta_keywords AS meta_keywords_8,
  COUNT(p1_.id) AS sclr_9,
  c0_.parent_id AS parent_id_10
FROM
  category c0_
  LEFT JOIN product_category p2_ ON c0_.id = p2_.category_id
  LEFT JOIN product p1_ ON p1_.id = p2_.product_id
WHERE
  c0_.active = ?
  AND c0_.parent_id IS NULL
GROUP BY
  c0_.id
ORDER BY
  c0_.position ASC,
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.image AS image_3, c0_.active AS active_4, c0_.position AS position_5, c0_.meta_title AS meta_title_6, c0_.meta_description AS meta_description_7, c0_.meta_keywords AS meta_keywords_8, COUNT(p1_.id) AS sclr_9, c0_.parent_id AS parent_id_10 FROM category c0_ LEFT JOIN product_category p2_ ON c0_.id = p2_.category_id LEFT JOIN product p1_ ON p1_.id = p2_.product_id WHERE c0_.active = 1 AND c0_.parent_id IS NULL GROUP BY c0_.id ORDER BY c0_.position ASC, c0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.cod AS cod_2,
  t0.reference AS reference_3,
  t0.name AS name_4,
  t0.description AS description_5,
  t0.slug AS slug_6,
  t0.stock AS stock_7,
  t0.pvp AS pvp_8,
  t0.discount AS discount_9,
  t0.net_price AS net_price_10,
  t0.extra AS extra_11,
  t0.images AS images_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.views AS views_15,
  t0.position AS position_16,
  t0.active AS active_17,
  t0.meta_title AS meta_title_18,
  t0.meta_description AS meta_description_19,
  t0.meta_keywords AS meta_keywords_20,
  t0.brand_id AS brand_id_21
FROM
  product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.position AS position_16, t0.active AS active_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.meta_keywords AS meta_keywords_20, t0.brand_id AS brand_id_21 FROM product t0 WHERE t0.id = 15309;

SELECT
  t0.id AS id_1,
  t0.cod AS cod_2,
  t0.reference AS reference_3,
  t0.name AS name_4,
  t0.description AS description_5,
  t0.slug AS slug_6,
  t0.stock AS stock_7,
  t0.pvp AS pvp_8,
  t0.discount AS discount_9,
  t0.net_price AS net_price_10,
  t0.extra AS extra_11,
  t0.images AS images_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.views AS views_15,
  t0.position AS position_16,
  t0.active AS active_17,
  t0.meta_title AS meta_title_18,
  t0.meta_description AS meta_description_19,
  t0.meta_keywords AS meta_keywords_20,
  t0.brand_id AS brand_id_21
FROM
  product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.position AS position_16, t0.active AS active_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.meta_keywords AS meta_keywords_20, t0.brand_id AS brand_id_21 FROM product t0 WHERE t0.id = 5026;

SELECT
  t0.id AS id_1,
  t0.cod AS cod_2,
  t0.reference AS reference_3,
  t0.name AS name_4,
  t0.description AS description_5,
  t0.slug AS slug_6,
  t0.stock AS stock_7,
  t0.pvp AS pvp_8,
  t0.discount AS discount_9,
  t0.net_price AS net_price_10,
  t0.extra AS extra_11,
  t0.images AS images_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.views AS views_15,
  t0.position AS position_16,
  t0.active AS active_17,
  t0.meta_title AS meta_title_18,
  t0.meta_description AS meta_description_19,
  t0.meta_keywords AS meta_keywords_20,
  t0.brand_id AS brand_id_21
FROM
  product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.position AS position_16, t0.active AS active_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.meta_keywords AS meta_keywords_20, t0.brand_id AS brand_id_21 FROM product t0 WHERE t0.id = 7881;

SELECT
  t0.id AS id_1,
  t0.cod AS cod_2,
  t0.reference AS reference_3,
  t0.name AS name_4,
  t0.description AS description_5,
  t0.slug AS slug_6,
  t0.stock AS stock_7,
  t0.pvp AS pvp_8,
  t0.discount AS discount_9,
  t0.net_price AS net_price_10,
  t0.extra AS extra_11,
  t0.images AS images_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.views AS views_15,
  t0.position AS position_16,
  t0.active AS active_17,
  t0.meta_title AS meta_title_18,
  t0.meta_description AS meta_description_19,
  t0.meta_keywords AS meta_keywords_20,
  t0.brand_id AS brand_id_21
FROM
  product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.position AS position_16, t0.active AS active_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.meta_keywords AS meta_keywords_20, t0.brand_id AS brand_id_21 FROM product t0 WHERE t0.id = 11687;

SELECT
  t0.id AS id_1,
  t0.cod AS cod_2,
  t0.reference AS reference_3,
  t0.name AS name_4,
  t0.description AS description_5,
  t0.slug AS slug_6,
  t0.stock AS stock_7,
  t0.pvp AS pvp_8,
  t0.discount AS discount_9,
  t0.net_price AS net_price_10,
  t0.extra AS extra_11,
  t0.images AS images_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.views AS views_15,
  t0.position AS position_16,
  t0.active AS active_17,
  t0.meta_title AS meta_title_18,
  t0.meta_description AS meta_description_19,
  t0.meta_keywords AS meta_keywords_20,
  t0.brand_id AS brand_id_21
FROM
  product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.position AS position_16, t0.active AS active_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.meta_keywords AS meta_keywords_20, t0.brand_id AS brand_id_21 FROM product t0 WHERE t0.id = 26011;

SELECT
  t0.id AS id_1,
  t0.cod AS cod_2,
  t0.reference AS reference_3,
  t0.name AS name_4,
  t0.description AS description_5,
  t0.slug AS slug_6,
  t0.stock AS stock_7,
  t0.pvp AS pvp_8,
  t0.discount AS discount_9,
  t0.net_price AS net_price_10,
  t0.extra AS extra_11,
  t0.images AS images_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.views AS views_15,
  t0.position AS position_16,
  t0.active AS active_17,
  t0.meta_title AS meta_title_18,
  t0.meta_description AS meta_description_19,
  t0.meta_keywords AS meta_keywords_20,
  t0.brand_id AS brand_id_21
FROM
  product t0
WHERE
  t0.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  t0.position ASC,
  t0.name ASC

SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.position AS position_16, t0.active AS active_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.meta_keywords AS meta_keywords_20, t0.brand_id AS brand_id_21 FROM product t0 WHERE t0.id IN (16139, 12670, 17373, 21281, 1513, 22561, 22612, 5086, 12454, 20603, 6681, 1974, 5064, 13234, 11194, 15600, 17980, 13479, 11505, 17963, 21434, 12118, 10594, 1519, 22625, 15602, 21511, 11000, 10624, 10626, 5074, 9994, 7926, 9095, 22617, 10998, 15288, 11300, 21454, 17731, 12125, 5077, 8572, 22627, 23553, 9777, 21324, 15665, 15196, 5092, 15685, 27579, 12211, 11888, 24066, 12806, 18742, 12695, 5032, 20905, 12317, 10597, 10625, 17695, 25106, 10350, 1566, 19820, 24071) ORDER BY t0.position ASC, t0.name ASC;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.image AS image_3,
  c0_.active AS active_4,
  c0_.position AS position_5,
  c0_.meta_title AS meta_title_6,
  c0_.meta_description AS meta_description_7,
  c0_.meta_keywords AS meta_keywords_8,
  COUNT(p1_.id) AS sclr_9,
  c0_.parent_id AS parent_id_10
FROM
  category c0_
  LEFT JOIN product_category p2_ ON c0_.id = p2_.category_id
  LEFT JOIN product p1_ ON p1_.id = p2_.product_id
WHERE
  c0_.active = ?
  AND c0_.parent_id IS NULL
GROUP BY
  c0_.id
ORDER BY
  c0_.position ASC,
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.image AS image_3, c0_.active AS active_4, c0_.position AS position_5, c0_.meta_title AS meta_title_6, c0_.meta_description AS meta_description_7, c0_.meta_keywords AS meta_keywords_8, COUNT(p1_.id) AS sclr_9, c0_.parent_id AS parent_id_10 FROM category c0_ LEFT JOIN product_category p2_ ON c0_.id = p2_.category_id LEFT JOIN product p1_ ON p1_.id = p2_.product_id WHERE c0_.active = 1 AND c0_.parent_id IS NULL GROUP BY c0_.id ORDER BY c0_.position ASC, c0_.name ASC;