Symfony Profiler

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.type AS type_2,
  COUNT(d1_.id) AS sclr_3
FROM
  Tag t0_
  INNER JOIN tag_deal t2_ ON t0_.id = t2_.tag_id
  INNER JOIN Deal d1_ ON d1_.id = t2_.deal_id
WHERE
  EXISTS (
    SELECT
      d3_.id
    FROM
      Deal d3_
    WHERE
      d3_.delayedTasks = 0
      AND d3_.activateDate IS NOT NULL
      AND d3_.expired = ?
      AND d3_.status NOT IN (1, 7, 5)
      AND d3_.id = d1_.id
  )
GROUP BY
  t0_.id
ORDER BY
  t0_.name ASC

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.type AS type_2, COUNT(d1_.id) AS sclr_3 FROM Tag t0_ INNER JOIN tag_deal t2_ ON t0_.id = t2_.tag_id INNER JOIN Deal d1_ ON d1_.id = t2_.deal_id WHERE EXISTS (SELECT d3_.id FROM Deal d3_ WHERE d3_.delayedTasks = 0 AND d3_.activateDate IS NOT NULL AND d3_.expired = 0 AND d3_.status NOT IN (1, 7, 5) AND d3_.id = d1_.id) GROUP BY t0_.id ORDER BY t0_.name ASC;

SELECT
  COUNT(1) AS sclr_0
FROM
  Deal d0_
WHERE
  d0_.delayedTasks = 0
  AND d0_.activateDate IS NOT NULL
  AND d0_.expired = ?
  AND d0_.status NOT IN (1, 7, 5)

SELECT COUNT(1) AS sclr_0 FROM Deal d0_ WHERE d0_.delayedTasks = 0 AND d0_.activateDate IS NOT NULL AND d0_.expired = 0 AND d0_.status NOT IN (1, 7, 5);

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          d0_.id AS id_0,
          d0_.status AS status_1,
          d0_.createdAt AS createdAt_2,
          d0_.lastModified AS lastModified_3,
          d0_.expireDate AS expireDate_4,
          d0_.expired AS expired_5,
          d0_.activateDate AS activateDate_6,
          d0_.fundedAt AS fundedAt_7,
          d0_.title AS title_8,
          d0_.stringId AS stringId_9,
          d0_.description AS description_10,
          d0_.featured AS featured_11,
          d0_.sexualOrientation AS sexualOrientation_12,
          d0_.contributorsCount AS contributorsCount_13,
          d0_.progress AS progress_14,
          d0_.previewFilename AS previewFilename_15,
          d0_.trailerFilenames AS trailerFilenames_16,
          d0_.galleryFilenames AS galleryFilenames_17,
          d0_.vidcapsGenerated AS vidcapsGenerated_18,
          d0_.vidcapsFilenames AS vidcapsFilenames_19,
          d0_.publishedVidcapsFilenames AS publishedVidcapsFilenames_20,
          d0_.adminNotes AS adminNotes_21,
          d0_.price AS price_22,
          d0_.contributed AS contributed_23,
          d0_.metaInfo AS metaInfo_24,
          d0_.delayedTasks AS delayedTasks_25
        FROM
          Deal d0_
        WHERE
          d0_.delayedTasks = 0
          AND d0_.activateDate IS NOT NULL
          AND d0_.expired = ?
          AND d0_.status NOT IN (1, 7, 5)
        ORDER BY
          d0_.activateDate DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT d0_.id AS id_0, d0_.status AS status_1, d0_.createdAt AS createdAt_2, d0_.lastModified AS lastModified_3, d0_.expireDate AS expireDate_4, d0_.expired AS expired_5, d0_.activateDate AS activateDate_6, d0_.fundedAt AS fundedAt_7, d0_.title AS title_8, d0_.stringId AS stringId_9, d0_.description AS description_10, d0_.featured AS featured_11, d0_.sexualOrientation AS sexualOrientation_12, d0_.contributorsCount AS contributorsCount_13, d0_.progress AS progress_14, d0_.previewFilename AS previewFilename_15, d0_.trailerFilenames AS trailerFilenames_16, d0_.galleryFilenames AS galleryFilenames_17, d0_.vidcapsGenerated AS vidcapsGenerated_18, d0_.vidcapsFilenames AS vidcapsFilenames_19, d0_.publishedVidcapsFilenames AS publishedVidcapsFilenames_20, d0_.adminNotes AS adminNotes_21, d0_.price AS price_22, d0_.contributed AS contributed_23, d0_.metaInfo AS metaInfo_24, d0_.delayedTasks AS delayedTasks_25 FROM Deal d0_ WHERE d0_.delayedTasks = 0 AND d0_.activateDate IS NOT NULL AND d0_.expired = 0 AND d0_.status NOT IN (1, 7, 5) ORDER BY d0_.activateDate DESC) dctrn_result) dctrn_table;

SELECT
  d0_.id AS id_0,
  d0_.status AS status_1,
  d0_.createdAt AS createdAt_2,
  d0_.lastModified AS lastModified_3,
  d0_.expireDate AS expireDate_4,
  d0_.expired AS expired_5,
  d0_.activateDate AS activateDate_6,
  d0_.fundedAt AS fundedAt_7,
  d0_.title AS title_8,
  d0_.stringId AS stringId_9,
  d0_.description AS description_10,
  d0_.featured AS featured_11,
  d0_.sexualOrientation AS sexualOrientation_12,
  d0_.contributorsCount AS contributorsCount_13,
  d0_.progress AS progress_14,
  d0_.previewFilename AS previewFilename_15,
  d0_.trailerFilenames AS trailerFilenames_16,
  d0_.galleryFilenames AS galleryFilenames_17,
  d0_.vidcapsGenerated AS vidcapsGenerated_18,
  d0_.vidcapsFilenames AS vidcapsFilenames_19,
  d0_.publishedVidcapsFilenames AS publishedVidcapsFilenames_20,
  d0_.adminNotes AS adminNotes_21,
  d0_.price AS price_22,
  d0_.contributed AS contributed_23,
  d0_.metaInfo AS metaInfo_24,
  d0_.delayedTasks AS delayedTasks_25
FROM
  Deal d0_
WHERE
  d0_.delayedTasks = 0
  AND d0_.activateDate IS NOT NULL
  AND d0_.expired = ?
  AND d0_.status NOT IN (1, 7, 5)
ORDER BY
  d0_.activateDate DESC
LIMIT
  12

SELECT d0_.id AS id_0, d0_.status AS status_1, d0_.createdAt AS createdAt_2, d0_.lastModified AS lastModified_3, d0_.expireDate AS expireDate_4, d0_.expired AS expired_5, d0_.activateDate AS activateDate_6, d0_.fundedAt AS fundedAt_7, d0_.title AS title_8, d0_.stringId AS stringId_9, d0_.description AS description_10, d0_.featured AS featured_11, d0_.sexualOrientation AS sexualOrientation_12, d0_.contributorsCount AS contributorsCount_13, d0_.progress AS progress_14, d0_.previewFilename AS previewFilename_15, d0_.trailerFilenames AS trailerFilenames_16, d0_.galleryFilenames AS galleryFilenames_17, d0_.vidcapsGenerated AS vidcapsGenerated_18, d0_.vidcapsFilenames AS vidcapsFilenames_19, d0_.publishedVidcapsFilenames AS publishedVidcapsFilenames_20, d0_.adminNotes AS adminNotes_21, d0_.price AS price_22, d0_.contributed AS contributed_23, d0_.metaInfo AS metaInfo_24, d0_.delayedTasks AS delayedTasks_25 FROM Deal d0_ WHERE d0_.delayedTasks = 0 AND d0_.activateDate IS NOT NULL AND d0_.expired = 0 AND d0_.status NOT IN (1, 7, 5) ORDER BY d0_.activateDate DESC LIMIT 12;

SELECT
  d0_.id AS id_0,
  d0_.status AS status_1,
  d0_.createdAt AS createdAt_2,
  d0_.lastModified AS lastModified_3,
  d0_.expireDate AS expireDate_4,
  d0_.expired AS expired_5,
  d0_.activateDate AS activateDate_6,
  d0_.fundedAt AS fundedAt_7,
  d0_.title AS title_8,
  d0_.stringId AS stringId_9,
  d0_.description AS description_10,
  d0_.featured AS featured_11,
  d0_.sexualOrientation AS sexualOrientation_12,
  d0_.contributorsCount AS contributorsCount_13,
  d0_.progress AS progress_14,
  d0_.previewFilename AS previewFilename_15,
  d0_.trailerFilenames AS trailerFilenames_16,
  d0_.galleryFilenames AS galleryFilenames_17,
  d0_.vidcapsGenerated AS vidcapsGenerated_18,
  d0_.vidcapsFilenames AS vidcapsFilenames_19,
  d0_.publishedVidcapsFilenames AS publishedVidcapsFilenames_20,
  d0_.adminNotes AS adminNotes_21,
  d0_.price AS price_22,
  d0_.contributed AS contributed_23,
  d0_.metaInfo AS metaInfo_24,
  d0_.delayedTasks AS delayedTasks_25
FROM
  Deal d0_
WHERE
  d0_.expired = ?
  AND d0_.price <= d0_.contributed
  AND d0_.status NOT IN (1, 7, 5)
ORDER BY
  d0_.expireDate DESC
LIMIT
  16

SELECT d0_.id AS id_0, d0_.status AS status_1, d0_.createdAt AS createdAt_2, d0_.lastModified AS lastModified_3, d0_.expireDate AS expireDate_4, d0_.expired AS expired_5, d0_.activateDate AS activateDate_6, d0_.fundedAt AS fundedAt_7, d0_.title AS title_8, d0_.stringId AS stringId_9, d0_.description AS description_10, d0_.featured AS featured_11, d0_.sexualOrientation AS sexualOrientation_12, d0_.contributorsCount AS contributorsCount_13, d0_.progress AS progress_14, d0_.previewFilename AS previewFilename_15, d0_.trailerFilenames AS trailerFilenames_16, d0_.galleryFilenames AS galleryFilenames_17, d0_.vidcapsGenerated AS vidcapsGenerated_18, d0_.vidcapsFilenames AS vidcapsFilenames_19, d0_.publishedVidcapsFilenames AS publishedVidcapsFilenames_20, d0_.adminNotes AS adminNotes_21, d0_.price AS price_22, d0_.contributed AS contributed_23, d0_.metaInfo AS metaInfo_24, d0_.delayedTasks AS delayedTasks_25 FROM Deal d0_ WHERE d0_.expired = 1 AND d0_.price <= d0_.contributed AND d0_.status NOT IN (1, 7, 5) ORDER BY d0_.expireDate DESC LIMIT 16;