Symfony Profiler

SELECT
  m0_.id AS id_0,
  m0_.name AS name_1,
  m0_.image AS image_2,
  m0_.active AS active_3
FROM
  media m0_

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.image AS image_2, m0_.active AS active_3 FROM media m0_;

SELECT
  i0_.id AS id_0,
  i0_.name AS name_1,
  i0_.description AS description_2,
  i0_.attribute AS attribute_3,
  i0_.item_url AS item_url_4,
  i0_.is_video AS is_video_5,
  i0_.active AS active_6,
  i0_.image AS image_7
FROM
  item i0_
  LEFT JOIN media_item m2_ ON i0_.id = m2_.item_id
  LEFT JOIN media m1_ ON m1_.id = m2_.media_id
  LEFT JOIN category_item c4_ ON i0_.id = c4_.item_id
  LEFT JOIN category c3_ ON c3_.id = c4_.category_id
ORDER BY
  i0_.name ASC

SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.description AS description_2, i0_.attribute AS attribute_3, i0_.item_url AS item_url_4, i0_.is_video AS is_video_5, i0_.active AS active_6, i0_.image AS image_7 FROM item i0_ LEFT JOIN media_item m2_ ON i0_.id = m2_.item_id LEFT JOIN media m1_ ON m1_.id = m2_.media_id LEFT JOIN category_item c4_ ON i0_.id = c4_.item_id LEFT JOIN category c3_ ON c3_.id = c4_.category_id ORDER BY i0_.name ASC;

SELECT
  i0_.id AS id_0,
  i0_.name AS name_1,
  i0_.description AS description_2,
  i0_.attribute AS attribute_3,
  i0_.item_url AS item_url_4,
  i0_.active AS active_5,
  i0_.is_video AS is_video_6,
  i0_.image AS image_7,
  SUM(v1_.vote) AS sclr_8
FROM
  item i0_
  INNER JOIN vote v1_ ON i0_.id = v1_.item_id
WHERE
  i0_.active = 1
  AND (
    i0_.id = ?
    OR i0_.id = ?
    OR i0_.id = ?
    OR i0_.id = ?
    OR i0_.id = ?
    OR i0_.id = ?
    OR i0_.id = ?
    OR i0_.id = ?
    OR i0_.id = ?
  )
GROUP BY
  i0_.id
ORDER BY
  i0_.name ASC
LIMIT
  9

SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.description AS description_2, i0_.attribute AS attribute_3, i0_.item_url AS item_url_4, i0_.active AS active_5, i0_.is_video AS is_video_6, i0_.image AS image_7, SUM(v1_.vote) AS sclr_8 FROM item i0_ INNER JOIN vote v1_ ON i0_.id = v1_.item_id WHERE i0_.active = 1 AND (i0_.id = '40' OR i0_.id = '56' OR i0_.id = '37' OR i0_.id = '52' OR i0_.id = '27' OR i0_.id = '7' OR i0_.id = '23' OR i0_.id = '25' OR i0_.id = '10') GROUP BY i0_.id ORDER BY i0_.name ASC LIMIT 9;

SELECT
  i0_.id AS id_0,
  i0_.name AS name_1,
  i0_.description AS description_2,
  i0_.attribute AS attribute_3,
  i0_.item_url AS item_url_4,
  i0_.active AS active_5,
  i0_.is_video AS is_video_6,
  i0_.image AS image_7,
  SUM(v1_.vote) AS sclr_8
FROM
  item i0_
  INNER JOIN vote v1_ ON i0_.id = v1_.item_id
WHERE
  i0_.active = 1
  AND (
    i0_.id = ?
    OR i0_.id = ?
    OR i0_.id = ?
  )
GROUP BY
  i0_.id

SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.description AS description_2, i0_.attribute AS attribute_3, i0_.item_url AS item_url_4, i0_.active AS active_5, i0_.is_video AS is_video_6, i0_.image AS image_7, SUM(v1_.vote) AS sclr_8 FROM item i0_ INNER JOIN vote v1_ ON i0_.id = v1_.item_id WHERE i0_.active = 1 AND (i0_.id = '40' OR i0_.id = '56' OR i0_.id = '27') GROUP BY i0_.id;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active AS active_3
FROM
  category t0
  INNER JOIN category_item ON t0.id = category_item.category_id
WHERE
  category_item.item_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3 FROM category t0 INNER JOIN category_item ON t0.id = category_item.category_id WHERE category_item.item_id = 23;

SELECT
  t0.id AS id_1,
  t0.vote AS vote_2,
  t0.item_id AS item_id_3
FROM
  vote t0
WHERE
  t0.item_id = ?

SELECT t0.id AS id_1, t0.vote AS vote_2, t0.item_id AS item_id_3 FROM vote t0 WHERE t0.item_id = 23;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active AS active_3
FROM
  category t0
  INNER JOIN category_item ON t0.id = category_item.category_id
WHERE
  category_item.item_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3 FROM category t0 INNER JOIN category_item ON t0.id = category_item.category_id WHERE category_item.item_id = 7;

SELECT
  t0.id AS id_1,
  t0.vote AS vote_2,
  t0.item_id AS item_id_3
FROM
  vote t0
WHERE
  t0.item_id = ?

SELECT t0.id AS id_1, t0.vote AS vote_2, t0.item_id AS item_id_3 FROM vote t0 WHERE t0.item_id = 7;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active AS active_3
FROM
  category t0
  INNER JOIN category_item ON t0.id = category_item.category_id
WHERE
  category_item.item_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3 FROM category t0 INNER JOIN category_item ON t0.id = category_item.category_id WHERE category_item.item_id = 40;

SELECT
  t0.id AS id_1,
  t0.vote AS vote_2,
  t0.item_id AS item_id_3
FROM
  vote t0
WHERE
  t0.item_id = ?

SELECT t0.id AS id_1, t0.vote AS vote_2, t0.item_id AS item_id_3 FROM vote t0 WHERE t0.item_id = 40;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active AS active_3
FROM
  category t0
  INNER JOIN category_item ON t0.id = category_item.category_id
WHERE
  category_item.item_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3 FROM category t0 INNER JOIN category_item ON t0.id = category_item.category_id WHERE category_item.item_id = 45;

SELECT
  t0.id AS id_1,
  t0.vote AS vote_2,
  t0.item_id AS item_id_3
FROM
  vote t0
WHERE
  t0.item_id = ?

SELECT t0.id AS id_1, t0.vote AS vote_2, t0.item_id AS item_id_3 FROM vote t0 WHERE t0.item_id = 45;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active AS active_3
FROM
  category t0
  INNER JOIN category_item ON t0.id = category_item.category_id
WHERE
  category_item.item_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3 FROM category t0 INNER JOIN category_item ON t0.id = category_item.category_id WHERE category_item.item_id = 15;

SELECT
  t0.id AS id_1,
  t0.vote AS vote_2,
  t0.item_id AS item_id_3
FROM
  vote t0
WHERE
  t0.item_id = ?

SELECT t0.id AS id_1, t0.vote AS vote_2, t0.item_id AS item_id_3 FROM vote t0 WHERE t0.item_id = 15;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active AS active_3
FROM
  category t0
  INNER JOIN category_item ON t0.id = category_item.category_id
WHERE
  category_item.item_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3 FROM category t0 INNER JOIN category_item ON t0.id = category_item.category_id WHERE category_item.item_id = 42;

SELECT
  t0.id AS id_1,
  t0.vote AS vote_2,
  t0.item_id AS item_id_3
FROM
  vote t0
WHERE
  t0.item_id = ?

SELECT t0.id AS id_1, t0.vote AS vote_2, t0.item_id AS item_id_3 FROM vote t0 WHERE t0.item_id = 42;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active AS active_3
FROM
  category t0
  INNER JOIN category_item ON t0.id = category_item.category_id
WHERE
  category_item.item_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3 FROM category t0 INNER JOIN category_item ON t0.id = category_item.category_id WHERE category_item.item_id = 71;

SELECT
  t0.id AS id_1,
  t0.vote AS vote_2,
  t0.item_id AS item_id_3
FROM
  vote t0
WHERE
  t0.item_id = ?

SELECT t0.id AS id_1, t0.vote AS vote_2, t0.item_id AS item_id_3 FROM vote t0 WHERE t0.item_id = 71;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active AS active_3
FROM
  category t0
  INNER JOIN category_item ON t0.id = category_item.category_id
WHERE
  category_item.item_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3 FROM category t0 INNER JOIN category_item ON t0.id = category_item.category_id WHERE category_item.item_id = 76;

SELECT
  t0.id AS id_1,
  t0.vote AS vote_2,
  t0.item_id AS item_id_3
FROM
  vote t0
WHERE
  t0.item_id = ?

SELECT t0.id AS id_1, t0.vote AS vote_2, t0.item_id AS item_id_3 FROM vote t0 WHERE t0.item_id = 76;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active AS active_3
FROM
  category t0
  INNER JOIN category_item ON t0.id = category_item.category_id
WHERE
  category_item.item_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3 FROM category t0 INNER JOIN category_item ON t0.id = category_item.category_id WHERE category_item.item_id = 24;

SELECT
  t0.id AS id_1,
  t0.vote AS vote_2,
  t0.item_id AS item_id_3
FROM
  vote t0
WHERE
  t0.item_id = ?

SELECT t0.id AS id_1, t0.vote AS vote_2, t0.item_id AS item_id_3 FROM vote t0 WHERE t0.item_id = 24;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active AS active_3
FROM
  category t0
  INNER JOIN category_item ON t0.id = category_item.category_id
WHERE
  category_item.item_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3 FROM category t0 INNER JOIN category_item ON t0.id = category_item.category_id WHERE category_item.item_id = 67;