Symfony Profiler

SELECT
  COUNT(DISTINCT d0_.id) AS sclr_0
FROM
  deal d0_

SELECT COUNT(DISTINCT d0_.id) AS sclr_0 FROM deal d0_;

SELECT
  DISTINCT d0_.id AS id_0,
  d0_.publicationdate AS publicationdate_1
FROM
  deal d0_
ORDER BY
  d0_.publicationdate DESC
LIMIT
  10

SELECT DISTINCT d0_.id AS id_0, d0_.publicationdate AS publicationdate_1 FROM deal d0_ ORDER BY d0_.publicationdate DESC LIMIT 10;

SELECT
  d0_.id AS id_0,
  d0_.title AS title_1,
  d0_.description AS description_2,
  d0_.initialprice AS initialprice_3,
  d0_.reduceprice AS reduceprice_4,
  d0_.publicationdate AS publicationdate_5,
  d0_.link AS link_6,
  d0_.delivery AS delivery_7,
  d0_.image_filename AS image_filename_8,
  d0_.is_active AS is_active_9,
  d0_.is_published AS is_published_10,
  d0_.user_id AS user_id_11
FROM
  deal d0_
WHERE
  d0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  d0_.publicationdate DESC

SELECT d0_.id AS id_0, d0_.title AS title_1, d0_.description AS description_2, d0_.initialprice AS initialprice_3, d0_.reduceprice AS reduceprice_4, d0_.publicationdate AS publicationdate_5, d0_.link AS link_6, d0_.delivery AS delivery_7, d0_.image_filename AS image_filename_8, d0_.is_active AS is_active_9, d0_.is_published AS is_published_10, d0_.user_id AS user_id_11 FROM deal d0_ WHERE d0_.id IN (62, 51, 65, 63, 36, 67, 53, 58, 64, 55) ORDER BY d0_.publicationdate DESC;

SELECT
  COUNT(*)
FROM
  vote t0
WHERE
  t0.deal_id = ?
  AND t0.type_vote = ?

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = 62 AND t0.type_vote = 'upvote';

SELECT
  COUNT(*)
FROM
  vote t0
WHERE
  t0.deal_id = ?
  AND t0.type_vote = ?

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = 62 AND t0.type_vote = 'downvote';

SELECT
  COUNT(*)
FROM
  vote t0
WHERE
  t0.deal_id = ?
  AND t0.type_vote = ?

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = 51 AND t0.type_vote = 'upvote';

SELECT
  COUNT(*)
FROM
  vote t0
WHERE
  t0.deal_id = ?
  AND t0.type_vote = ?

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = 51 AND t0.type_vote = 'downvote';

SELECT
  COUNT(*)
FROM
  vote t0
WHERE
  t0.deal_id = ?
  AND t0.type_vote = ?

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = 65 AND t0.type_vote = 'upvote';

SELECT
  COUNT(*)
FROM
  vote t0
WHERE
  t0.deal_id = ?
  AND t0.type_vote = ?

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = 65 AND t0.type_vote = 'downvote';

SELECT
  COUNT(*)
FROM
  vote t0
WHERE
  t0.deal_id = ?
  AND t0.type_vote = ?

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = 63 AND t0.type_vote = 'upvote';

SELECT
  COUNT(*)
FROM
  vote t0
WHERE
  t0.deal_id = ?
  AND t0.type_vote = ?

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = 63 AND t0.type_vote = 'downvote';

SELECT
  COUNT(*)
FROM
  vote t0
WHERE
  t0.deal_id = ?
  AND t0.type_vote = ?

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = 36 AND t0.type_vote = 'upvote';

SELECT
  COUNT(*)
FROM
  vote t0
WHERE
  t0.deal_id = ?
  AND t0.type_vote = ?

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = 36 AND t0.type_vote = 'downvote';

SELECT
  COUNT(*)
FROM
  vote t0
WHERE
  t0.deal_id = ?
  AND t0.type_vote = ?

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = 67 AND t0.type_vote = 'upvote';

SELECT
  COUNT(*)
FROM
  vote t0
WHERE
  t0.deal_id = ?
  AND t0.type_vote = ?

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = 67 AND t0.type_vote = 'downvote';

SELECT
  COUNT(*)
FROM
  vote t0
WHERE
  t0.deal_id = ?
  AND t0.type_vote = ?

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = 53 AND t0.type_vote = 'upvote';

SELECT
  COUNT(*)
FROM
  vote t0
WHERE
  t0.deal_id = ?
  AND t0.type_vote = ?

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = 53 AND t0.type_vote = 'downvote';

SELECT
  COUNT(*)
FROM
  vote t0
WHERE
  t0.deal_id = ?
  AND t0.type_vote = ?

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = 58 AND t0.type_vote = 'upvote';

SELECT
  COUNT(*)
FROM
  vote t0
WHERE
  t0.deal_id = ?
  AND t0.type_vote = ?

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = 58 AND t0.type_vote = 'downvote';

SELECT
  COUNT(*)
FROM
  vote t0
WHERE
  t0.deal_id = ?
  AND t0.type_vote = ?

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = 64 AND t0.type_vote = 'upvote';

SELECT
  COUNT(*)
FROM
  vote t0
WHERE
  t0.deal_id = ?
  AND t0.type_vote = ?

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = 64 AND t0.type_vote = 'downvote';

SELECT
  COUNT(*)
FROM
  vote t0
WHERE
  t0.deal_id = ?
  AND t0.type_vote = ?

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = 55 AND t0.type_vote = 'upvote';

SELECT
  COUNT(*)
FROM
  vote t0
WHERE
  t0.deal_id = ?
  AND t0.type_vote = ?

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = 55 AND t0.type_vote = 'downvote';

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.initialprice AS initialprice_4,
  t0.reduceprice AS reduceprice_5,
  t0.publicationdate AS publicationdate_6,
  t0.link AS link_7,
  t0.delivery AS delivery_8,
  t0.image_filename AS image_filename_9,
  t0.is_active AS is_active_10,
  t0.is_published AS is_published_11,
  t0.user_id AS user_id_12
FROM
  deal t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.initialprice AS initialprice_4, t0.reduceprice AS reduceprice_5, t0.publicationdate AS publicationdate_6, t0.link AS link_7, t0.delivery AS delivery_8, t0.image_filename AS image_filename_9, t0.is_active AS is_active_10, t0.is_published AS is_published_11, t0.user_id AS user_id_12 FROM deal t0;

SELECT
  COUNT(*)
FROM
  vote t0
WHERE
  t0.deal_id = ?
  AND t0.type_vote = ?

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = 36 AND t0.type_vote = 'upvote';

SELECT
  COUNT(*)
FROM
  vote t0
WHERE
  t0.deal_id = ?
  AND t0.type_vote = ?

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = 36 AND t0.type_vote = 'downvote';

SELECT
  COUNT(*)
FROM
  vote t0
WHERE
  t0.deal_id = ?
  AND t0.type_vote = ?

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = 37 AND t0.type_vote = 'upvote';

SELECT
  COUNT(*)
FROM
  vote t0
WHERE
  t0.deal_id = ?
  AND t0.type_vote = ?

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = 37 AND t0.type_vote = 'downvote';

SELECT
  COUNT(*)
FROM
  vote t0
WHERE
  t0.deal_id = ?
  AND t0.type_vote = ?

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = 38 AND t0.type_vote = 'upvote';

SELECT
  COUNT(*)
FROM
  vote t0
WHERE
  t0.deal_id = ?
  AND t0.type_vote = ?

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = 38 AND t0.type_vote = 'downvote';

SELECT
  COUNT(*)
FROM
  vote t0
WHERE
  t0.deal_id = ?
  AND t0.type_vote = ?

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = 39 AND t0.type_vote = 'upvote';

SELECT
  COUNT(*)
FROM
  vote t0
WHERE
  t0.deal_id = ?
  AND t0.type_vote = ?

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = 39 AND t0.type_vote = 'downvote';

SELECT
  COUNT(*)
FROM
  vote t0
WHERE
  t0.deal_id = ?
  AND t0.type_vote = ?

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = 40 AND t0.type_vote = 'upvote';

SELECT
  COUNT(*)
FROM
  vote t0
WHERE
  t0.deal_id = ?
  AND t0.type_vote = ?

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = 40 AND t0.type_vote = 'downvote';

SELECT
  COUNT(*)
FROM
  vote t0
WHERE
  t0.deal_id = ?
  AND t0.type_vote = ?

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = 41 AND t0.type_vote = 'upvote';

SELECT
  COUNT(*)
FROM
  vote t0
WHERE
  t0.deal_id = ?
  AND t0.type_vote = ?

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = 41 AND t0.type_vote = 'downvote';

SELECT
  COUNT(*)
FROM
  vote t0
WHERE
  t0.deal_id = ?
  AND t0.type_vote = ?

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = 42 AND t0.type_vote = 'upvote';

SELECT
  COUNT(*)
FROM
  vote t0
WHERE
  t0.deal_id = ?
  AND t0.type_vote = ?

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = 42 AND t0.type_vote = 'downvote';

SELECT
  COUNT(*)
FROM
  vote t0
WHERE
  t0.deal_id = ?
  AND t0.type_vote = ?

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = 43 AND t0.type_vote = 'upvote';

SELECT
  COUNT(*)
FROM
  vote t0
WHERE
  t0.deal_id = ?
  AND t0.type_vote = ?

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = 43 AND t0.type_vote = 'downvote';

SELECT
  COUNT(*)
FROM
  vote t0
WHERE
  t0.deal_id = ?
  AND t0.type_vote = ?

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = 44 AND t0.type_vote = 'upvote';

SELECT
  COUNT(*)
FROM
  vote t0
WHERE
  t0.deal_id = ?
  AND t0.type_vote = ?

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = 44 AND t0.type_vote = 'downvote';

SELECT
  COUNT(*)
FROM
  vote t0
WHERE
  t0.deal_id = ?
  AND t0.type_vote = ?

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = 45 AND t0.type_vote = 'upvote';

SELECT
  COUNT(*)
FROM
  vote t0
WHERE
  t0.deal_id = ?
  AND t0.type_vote = ?

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = 45 AND t0.type_vote = 'downvote';

SELECT
  COUNT(*)
FROM
  vote t0
WHERE
  t0.deal_id = ?
  AND t0.type_vote = ?

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = 46 AND t0.type_vote = 'upvote';

SELECT
  COUNT(*)
FROM
  vote t0
WHERE
  t0.deal_id = ?
  AND t0.type_vote = ?

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = 46 AND t0.type_vote = 'downvote';

SELECT
  COUNT(*)
FROM
  vote t0
WHERE
  t0.deal_id = ?
  AND t0.type_vote = ?

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = 47 AND t0.type_vote = 'upvote';

SELECT
  COUNT(*)
FROM
  vote t0
WHERE
  t0.deal_id = ?
  AND t0.type_vote = ?

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = 47 AND t0.type_vote = 'downvote';

SELECT
  COUNT(*)
FROM
  vote t0
WHERE
  t0.deal_id = ?
  AND t0.type_vote = ?