Symfony Profiler

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

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = 48 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 = 48 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 = 49 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 = 49 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 = 50 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 = 50 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 = 52 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 = 52 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 = 54 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 = 54 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
  COUNT(*)
FROM
  vote t0
WHERE
  t0.deal_id = ?
  AND t0.type_vote = ?

SELECT COUNT(*) FROM vote t0 WHERE t0.deal_id = 56 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 = 56 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 = 57 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 = 57 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 = 59 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 = 59 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 = 60 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 = 60 AND t0.type_vote = 'downvote';

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