Symfony Profiler

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.type AS type_2,
  COUNT(s1_.id) AS sclr_3
FROM
  Tag t0_
  INNER JOIN tag_shopvideo t2_ ON t0_.id = t2_.tag_id
  INNER JOIN ShopVideo s1_ ON s1_.id = t2_.shopvideo_id
WHERE
  EXISTS (
    SELECT
      s3_.id
    FROM
      ShopVideo s3_
    WHERE
      s3_.delayedTasks = 0
      AND s3_.activateDate IS NOT NULL
      AND s3_.status NOT IN (1, 7, 5)
      AND s3_.id = s1_.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(s1_.id) AS sclr_3 FROM Tag t0_ INNER JOIN tag_shopvideo t2_ ON t0_.id = t2_.tag_id INNER JOIN ShopVideo s1_ ON s1_.id = t2_.shopvideo_id WHERE EXISTS (SELECT s3_.id FROM ShopVideo s3_ WHERE s3_.delayedTasks = 0 AND s3_.activateDate IS NOT NULL AND s3_.status NOT IN (1, 7, 5) AND s3_.id = s1_.id) GROUP BY t0_.id ORDER BY t0_.name ASC;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          s0_.id AS id_0,
          s0_.status AS status_1,
          s0_.createdAt AS createdAt_2,
          s0_.lastModified AS lastModified_3,
          s0_.activateDate AS activateDate_4,
          s0_.title AS title_5,
          s0_.stringId AS stringId_6,
          s0_.description AS description_7,
          s0_.featured AS featured_8,
          s0_.sexualOrientation AS sexualOrientation_9,
          s0_.previewFilename AS previewFilename_10,
          s0_.trailerFilename AS trailerFilename_11,
          s0_.galleryFilenames AS galleryFilenames_12,
          s0_.vidcapsGenerated AS vidcapsGenerated_13,
          s0_.vidcapsFilenames AS vidcapsFilenames_14,
          s0_.publishedVidcapsFilenames AS publishedVidcapsFilenames_15,
          s0_.adminNotes AS adminNotes_16,
          s0_.price AS price_17,
          s0_.metaInfo AS metaInfo_18,
          s0_.delayedTasks AS delayedTasks_19
        FROM
          ShopVideo s0_
        WHERE
          s0_.delayedTasks = 0
          AND s0_.activateDate IS NOT NULL
          AND s0_.status NOT IN (1, 7, 5)
        ORDER BY
          s0_.activateDate DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT s0_.id AS id_0, s0_.status AS status_1, s0_.createdAt AS createdAt_2, s0_.lastModified AS lastModified_3, s0_.activateDate AS activateDate_4, s0_.title AS title_5, s0_.stringId AS stringId_6, s0_.description AS description_7, s0_.featured AS featured_8, s0_.sexualOrientation AS sexualOrientation_9, s0_.previewFilename AS previewFilename_10, s0_.trailerFilename AS trailerFilename_11, s0_.galleryFilenames AS galleryFilenames_12, s0_.vidcapsGenerated AS vidcapsGenerated_13, s0_.vidcapsFilenames AS vidcapsFilenames_14, s0_.publishedVidcapsFilenames AS publishedVidcapsFilenames_15, s0_.adminNotes AS adminNotes_16, s0_.price AS price_17, s0_.metaInfo AS metaInfo_18, s0_.delayedTasks AS delayedTasks_19 FROM ShopVideo s0_ WHERE s0_.delayedTasks = 0 AND s0_.activateDate IS NOT NULL AND s0_.status NOT IN (1, 7, 5) ORDER BY s0_.activateDate DESC) dctrn_result) dctrn_table;

SELECT
  s0_.id AS id_0,
  s0_.status AS status_1,
  s0_.createdAt AS createdAt_2,
  s0_.lastModified AS lastModified_3,
  s0_.activateDate AS activateDate_4,
  s0_.title AS title_5,
  s0_.stringId AS stringId_6,
  s0_.description AS description_7,
  s0_.featured AS featured_8,
  s0_.sexualOrientation AS sexualOrientation_9,
  s0_.previewFilename AS previewFilename_10,
  s0_.trailerFilename AS trailerFilename_11,
  s0_.galleryFilenames AS galleryFilenames_12,
  s0_.vidcapsGenerated AS vidcapsGenerated_13,
  s0_.vidcapsFilenames AS vidcapsFilenames_14,
  s0_.publishedVidcapsFilenames AS publishedVidcapsFilenames_15,
  s0_.adminNotes AS adminNotes_16,
  s0_.price AS price_17,
  s0_.metaInfo AS metaInfo_18,
  s0_.delayedTasks AS delayedTasks_19
FROM
  ShopVideo s0_
WHERE
  s0_.delayedTasks = 0
  AND s0_.activateDate IS NOT NULL
  AND s0_.status NOT IN (1, 7, 5)
ORDER BY
  s0_.activateDate DESC
LIMIT
  12

SELECT s0_.id AS id_0, s0_.status AS status_1, s0_.createdAt AS createdAt_2, s0_.lastModified AS lastModified_3, s0_.activateDate AS activateDate_4, s0_.title AS title_5, s0_.stringId AS stringId_6, s0_.description AS description_7, s0_.featured AS featured_8, s0_.sexualOrientation AS sexualOrientation_9, s0_.previewFilename AS previewFilename_10, s0_.trailerFilename AS trailerFilename_11, s0_.galleryFilenames AS galleryFilenames_12, s0_.vidcapsGenerated AS vidcapsGenerated_13, s0_.vidcapsFilenames AS vidcapsFilenames_14, s0_.publishedVidcapsFilenames AS publishedVidcapsFilenames_15, s0_.adminNotes AS adminNotes_16, s0_.price AS price_17, s0_.metaInfo AS metaInfo_18, s0_.delayedTasks AS delayedTasks_19 FROM ShopVideo s0_ WHERE s0_.delayedTasks = 0 AND s0_.activateDate IS NOT NULL AND s0_.status NOT IN (1, 7, 5) ORDER BY s0_.activateDate DESC LIMIT 12;

SELECT
  COUNT(1) AS sclr_0
FROM
  ShopVideo s0_
WHERE
  s0_.delayedTasks = 0
  AND s0_.activateDate IS NOT NULL
  AND s0_.status NOT IN (1, 7, 5)

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