https://www.dressyfun.com/video/more-shop-video-posted2

Query Metrics

4 Database Queries
3 Different statements
1.67 ms Query time
0 Invalid entities
0 Cache hits
3 Cache misses
3 Cache puts

Grouped Statements

Show all queries

Time Count Info
0.74 ms
(44.38%)
2
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.shopVideo_id AS shopVideo_id_11 FROM ShopVideoFile t0 WHERE t0.shopVideo_id = ?
Parameters:
[
  3
]
0.56 ms
(33.51%)
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_.stringId = ? AND s0_.delayedTasks = 0 AND s0_.activateDate IS NOT NULL AND s0_.status NOT IN (1, 7, 5)
Parameters:
[
  "more-shop-video-posted2"
]
0.37 ms
(22.11%)
1
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_shopvideo ON t0.id = tag_shopvideo.tag_id WHERE tag_shopvideo.shopvideo_id = ?
Parameters:
[
  3
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

0 Hits
3 Misses
3 Puts

Number of cache misses

Region Misses
cache_shop_video 2
categorization 1

Number of cache puts

Region Puts
cache_shop_video 2
categorization 1

Entities Mapping

Class Mapping errors
App\Entity\ShopVideo No errors.
App\Entity\Performer No errors.
App\Entity\Tag 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.
App\Entity\ProposalBid No errors.
App\Entity\ProjectBid No errors.
App\Entity\Favorite No errors.
App\Entity\Proposal No errors.
App\Entity\Deal No errors.
App\Entity\Project No errors.
App\Entity\Message\Message No errors.