Symfony Profiler

SELECT
  t0.fileSize AS fileSize_1,
  t0.width AS width_2,
  t0.height AS height_3,
  t0.runTime AS runTime_4,
  t0.mainSource AS mainSource_5,
  t0.id AS id_6,
  t0.name AS name_7,
  t0.originalName AS originalName_8,
  t0.createdAt AS createdAt_9,
  t0.`md5sum` AS md5sum_10,
  t0.deal_id AS deal_id_11
FROM
  DealVideoFile t0
WHERE
  t0.deal_id = ?

SELECT t0.fileSize AS fileSize_1, t0.width AS width_2, t0.height AS height_3, t0.runTime AS runTime_4, t0.mainSource AS mainSource_5, t0.id AS id_6, t0.name AS name_7, t0.originalName AS originalName_8, t0.createdAt AS createdAt_9, t0.`md5sum` AS md5sum_10, t0.deal_id AS deal_id_11 FROM DealVideoFile t0 WHERE t0.deal_id = 4;

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_.stringId = ?
  AND d0_.delayedTasks = 0
  AND d0_.activateDate IS NOT NULL
  AND d0_.expired = ?
  AND d0_.status NOT IN (1, 7, 5)

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_.stringId = 'funded-deal' AND d0_.delayedTasks = 0 AND d0_.activateDate IS NOT NULL AND d0_.expired = 0 AND d0_.status NOT IN (1, 7, 5);

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_.stringId = ?
  AND d0_.expired = ?
  AND d0_.status NOT IN (1, 7, 5)

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_.stringId = 'funded-deal' AND d0_.expired = 1 AND d0_.status NOT IN (1, 7, 5);

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.lastModified AS lastModified_3,
  t0.type AS type_4,
  t0.sexualOrientation AS sexualOrientation_5,
  t0.previewFilename AS previewFilename_6,
  t0.dealsCount AS dealsCount_7,
  t0.projectsCount AS projectsCount_8,
  t0.shopVideosCount AS shopVideosCount_9
FROM
  Tag t0
  INNER JOIN tag_deal ON t0.id = tag_deal.tag_id
WHERE
  tag_deal.deal_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.lastModified AS lastModified_3, t0.type AS type_4, t0.sexualOrientation AS sexualOrientation_5, t0.previewFilename AS previewFilename_6, t0.dealsCount AS dealsCount_7, t0.projectsCount AS projectsCount_8, t0.shopVideosCount AS shopVideosCount_9 FROM Tag t0 INNER JOIN tag_deal ON t0.id = tag_deal.tag_id WHERE tag_deal.deal_id = 4;