Query Metrics
4
Database Queries
4
Different statements
2.13 ms
Query time
0
Invalid entities
0
Cache hits
0
Cache misses
0
Cache puts
Grouped Statements
Time▼ | Count | Info |
---|---|---|
0.97 ms (45.64%) |
1 |
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
Parameters:
[] |
0.49 ms (23.22%) |
1 |
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
Parameters:
[] |
0.38 ms (17.96%) |
1 |
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
Parameters:
[] |
0.28 ms (13.18%) |
1 |
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)
Parameters:
[] |
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
0
Hits
0
Misses
0
Puts
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\ShopVideo | No errors. |
App\Entity\Tag | No errors. |
App\Entity\Proposal | No errors. |
App\Entity\Deal | No errors. |
App\Entity\Project | No errors. |
App\Entity\ProposalBid | No errors. |
App\Entity\ProjectBid | No errors. |
App\Entity\Favorite | No errors. |
App\Entity\Performer | No errors. |
App\Entity\InternalTag | No errors. |
App\Entity\Language | No errors. |
App\Entity\ShopVideoBid | No errors. |
UploadsBundle\Entity\FileEntity | No errors. |
App\Entity\ShopVideoFile | No errors. |
App\Entity\Feed | No errors. |