Query Metrics
4
Database Queries
3
Different statements
1.43 ms
Query time
0
Invalid entities
0
Cache hits
3
Cache misses
3
Cache puts
Grouped Statements
Time▼ | Count | Info |
---|---|---|
0.60 ms (41.73%) |
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:
[
8
]
|
0.51 ms (35.69%) |
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:
[
"shop-video-posted-2"
]
|
0.32 ms (22.59%) |
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:
[
8
]
|
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. |