GET https://dollypass.netperv.com/

Query Metrics

31 Database Queries
4 Different statements
19.54 ms Query time
0 Invalid entities
82 Managed entities
0 Cache hits
29 Cache misses
29 Cache puts

Queries

Group similar statements

# Time Info
1 0.90 ms
SELECT s0_.id AS id_0, s0_.enabled AS enabled_1, s0_.name AS name_2, s0_.description AS description_3, s0_.domain AS domain_4, s0_.sorting AS sorting_5, s0_.lastModified AS lastModified_6, s0_.headerFilename AS headerFilename_7, s0_.logo AS logo_8, s0_.icon AS icon_9, s0_.trailerFilename AS trailerFilename_10 FROM Satellite s0_ WHERE s0_.name = ? AND s0_.enabled = ? ORDER BY s0_.id ASC
Parameters:
[
  "adultoriginals"
  "1"
]
2 4.59 ms
SELECT s0_.id AS id_0, s0_.status AS status_1, s0_.createdAt AS createdAt_2, s0_.lastModified AS lastModified_3, s0_.title AS title_4, s0_.stringId AS stringId_5, s0_.description AS description_6, s0_.featured AS featured_7, s0_.sexualOrientation AS sexualOrientation_8, s0_.previewFilename AS previewFilename_9, s0_.trailerFilename AS trailerFilename_10, s0_.videoPreviewFilename AS videoPreviewFilename_11, s0_.videoSubtitleFilename AS videoSubtitleFilename_12, s0_.safePreviewFilename AS safePreviewFilename_13, s0_.galleryFilenames AS galleryFilenames_14, s0_.vidcapsGenerated AS vidcapsGenerated_15, s0_.vidcapsFilenames AS vidcapsFilenames_16, s0_.publishedVidcapsFilenames AS publishedVidcapsFilenames_17, s0_.adminNotes AS adminNotes_18, s0_.price AS price_19, s0_.streamMovieUrls AS streamMovieUrls_20, s0_.metaInfo AS metaInfo_21, s0_.delayedTasks AS delayedTasks_22 FROM ShopVideo s0_ INNER JOIN SatelliteContent s1_ ON s0_.id = s1_.shopVideo_id WHERE s1_.satellite_id = ? AND s0_.delayedTasks = 0 AND s1_.activateDate IS NOT NULL AND s0_.status = ? ORDER BY s1_.activateDate DESC LIMIT 24
Parameters:
[
  9
  "2"
]
3 0.81 ms
SELECT t0.id AS id_1, t0.activateDate AS activateDate_2, t0.main AS main_3, t0.lastModified AS lastModified_4, t0.shopVideo_id AS shopVideo_id_5, t0.satellite_id AS satellite_id_6, t0.series_id AS series_id_7 FROM SatelliteContent t0 WHERE t0.shopVideo_id = ?
Parameters:
[
  88
]
4 0.77 ms
SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.name AS name_3, t0.description AS description_4, t0.domain AS domain_5, t0.sorting AS sorting_6, t0.lastModified AS lastModified_7, t0.headerFilename AS headerFilename_8, t0.logo AS logo_9, t0.icon AS icon_10, t0.trailerFilename AS trailerFilename_11 FROM Satellite t0 WHERE t0.id = ?
Parameters:
[
  1
]
5 0.56 ms
SELECT t0.id AS id_1, t0.activateDate AS activateDate_2, t0.main AS main_3, t0.lastModified AS lastModified_4, t0.shopVideo_id AS shopVideo_id_5, t0.satellite_id AS satellite_id_6, t0.series_id AS series_id_7 FROM SatelliteContent t0 WHERE t0.shopVideo_id = ?
Parameters:
[
  117
]
6 0.59 ms
SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.name AS name_3, t0.description AS description_4, t0.domain AS domain_5, t0.sorting AS sorting_6, t0.lastModified AS lastModified_7, t0.headerFilename AS headerFilename_8, t0.logo AS logo_9, t0.icon AS icon_10, t0.trailerFilename AS trailerFilename_11 FROM Satellite t0 WHERE t0.id = ?
Parameters:
[
  8
]
7 0.43 ms
SELECT t0.id AS id_1, t0.activateDate AS activateDate_2, t0.main AS main_3, t0.lastModified AS lastModified_4, t0.shopVideo_id AS shopVideo_id_5, t0.satellite_id AS satellite_id_6, t0.series_id AS series_id_7 FROM SatelliteContent t0 WHERE t0.shopVideo_id = ?
Parameters:
[
  124
]
8 0.48 ms
SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.name AS name_3, t0.description AS description_4, t0.domain AS domain_5, t0.sorting AS sorting_6, t0.lastModified AS lastModified_7, t0.headerFilename AS headerFilename_8, t0.logo AS logo_9, t0.icon AS icon_10, t0.trailerFilename AS trailerFilename_11 FROM Satellite t0 WHERE t0.id = ?
Parameters:
[
  3
]
9 0.46 ms
SELECT t0.id AS id_1, t0.activateDate AS activateDate_2, t0.main AS main_3, t0.lastModified AS lastModified_4, t0.shopVideo_id AS shopVideo_id_5, t0.satellite_id AS satellite_id_6, t0.series_id AS series_id_7 FROM SatelliteContent t0 WHERE t0.shopVideo_id = ?
Parameters:
[
  95
]
10 0.73 ms
SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.name AS name_3, t0.description AS description_4, t0.domain AS domain_5, t0.sorting AS sorting_6, t0.lastModified AS lastModified_7, t0.headerFilename AS headerFilename_8, t0.logo AS logo_9, t0.icon AS icon_10, t0.trailerFilename AS trailerFilename_11 FROM Satellite t0 WHERE t0.id = ?
Parameters:
[
  2
]
11 0.44 ms
SELECT t0.id AS id_1, t0.activateDate AS activateDate_2, t0.main AS main_3, t0.lastModified AS lastModified_4, t0.shopVideo_id AS shopVideo_id_5, t0.satellite_id AS satellite_id_6, t0.series_id AS series_id_7 FROM SatelliteContent t0 WHERE t0.shopVideo_id = ?
Parameters:
[
  98
]
12 0.46 ms
SELECT t0.id AS id_1, t0.activateDate AS activateDate_2, t0.main AS main_3, t0.lastModified AS lastModified_4, t0.shopVideo_id AS shopVideo_id_5, t0.satellite_id AS satellite_id_6, t0.series_id AS series_id_7 FROM SatelliteContent t0 WHERE t0.shopVideo_id = ?
Parameters:
[
  87
]
13 0.44 ms
SELECT t0.id AS id_1, t0.activateDate AS activateDate_2, t0.main AS main_3, t0.lastModified AS lastModified_4, t0.shopVideo_id AS shopVideo_id_5, t0.satellite_id AS satellite_id_6, t0.series_id AS series_id_7 FROM SatelliteContent t0 WHERE t0.shopVideo_id = ?
Parameters:
[
  82
]
14 0.44 ms
SELECT t0.id AS id_1, t0.activateDate AS activateDate_2, t0.main AS main_3, t0.lastModified AS lastModified_4, t0.shopVideo_id AS shopVideo_id_5, t0.satellite_id AS satellite_id_6, t0.series_id AS series_id_7 FROM SatelliteContent t0 WHERE t0.shopVideo_id = ?
Parameters:
[
  135
]
15 0.45 ms
SELECT t0.id AS id_1, t0.activateDate AS activateDate_2, t0.main AS main_3, t0.lastModified AS lastModified_4, t0.shopVideo_id AS shopVideo_id_5, t0.satellite_id AS satellite_id_6, t0.series_id AS series_id_7 FROM SatelliteContent t0 WHERE t0.shopVideo_id = ?
Parameters:
[
  119
]
16 0.45 ms
SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.name AS name_3, t0.description AS description_4, t0.domain AS domain_5, t0.sorting AS sorting_6, t0.lastModified AS lastModified_7, t0.headerFilename AS headerFilename_8, t0.logo AS logo_9, t0.icon AS icon_10, t0.trailerFilename AS trailerFilename_11 FROM Satellite t0 WHERE t0.id = ?
Parameters:
[
  6
]
17 0.45 ms
SELECT t0.id AS id_1, t0.activateDate AS activateDate_2, t0.main AS main_3, t0.lastModified AS lastModified_4, t0.shopVideo_id AS shopVideo_id_5, t0.satellite_id AS satellite_id_6, t0.series_id AS series_id_7 FROM SatelliteContent t0 WHERE t0.shopVideo_id = ?
Parameters:
[
  52
]
18 0.44 ms
SELECT t0.id AS id_1, t0.activateDate AS activateDate_2, t0.main AS main_3, t0.lastModified AS lastModified_4, t0.shopVideo_id AS shopVideo_id_5, t0.satellite_id AS satellite_id_6, t0.series_id AS series_id_7 FROM SatelliteContent t0 WHERE t0.shopVideo_id = ?
Parameters:
[
  133
]
19 0.45 ms
SELECT t0.id AS id_1, t0.activateDate AS activateDate_2, t0.main AS main_3, t0.lastModified AS lastModified_4, t0.shopVideo_id AS shopVideo_id_5, t0.satellite_id AS satellite_id_6, t0.series_id AS series_id_7 FROM SatelliteContent t0 WHERE t0.shopVideo_id = ?
Parameters:
[
  128
]
20 0.47 ms
SELECT t0.id AS id_1, t0.activateDate AS activateDate_2, t0.main AS main_3, t0.lastModified AS lastModified_4, t0.shopVideo_id AS shopVideo_id_5, t0.satellite_id AS satellite_id_6, t0.series_id AS series_id_7 FROM SatelliteContent t0 WHERE t0.shopVideo_id = ?
Parameters:
[
  122
]
21 0.45 ms
SELECT t0.id AS id_1, t0.activateDate AS activateDate_2, t0.main AS main_3, t0.lastModified AS lastModified_4, t0.shopVideo_id AS shopVideo_id_5, t0.satellite_id AS satellite_id_6, t0.series_id AS series_id_7 FROM SatelliteContent t0 WHERE t0.shopVideo_id = ?
Parameters:
[
  107
]
22 0.47 ms
SELECT t0.id AS id_1, t0.activateDate AS activateDate_2, t0.main AS main_3, t0.lastModified AS lastModified_4, t0.shopVideo_id AS shopVideo_id_5, t0.satellite_id AS satellite_id_6, t0.series_id AS series_id_7 FROM SatelliteContent t0 WHERE t0.shopVideo_id = ?
Parameters:
[
  120
]
23 0.44 ms
SELECT t0.id AS id_1, t0.activateDate AS activateDate_2, t0.main AS main_3, t0.lastModified AS lastModified_4, t0.shopVideo_id AS shopVideo_id_5, t0.satellite_id AS satellite_id_6, t0.series_id AS series_id_7 FROM SatelliteContent t0 WHERE t0.shopVideo_id = ?
Parameters:
[
  151
]
24 0.44 ms
SELECT t0.id AS id_1, t0.activateDate AS activateDate_2, t0.main AS main_3, t0.lastModified AS lastModified_4, t0.shopVideo_id AS shopVideo_id_5, t0.satellite_id AS satellite_id_6, t0.series_id AS series_id_7 FROM SatelliteContent t0 WHERE t0.shopVideo_id = ?
Parameters:
[
  127
]
25 0.43 ms
SELECT t0.id AS id_1, t0.activateDate AS activateDate_2, t0.main AS main_3, t0.lastModified AS lastModified_4, t0.shopVideo_id AS shopVideo_id_5, t0.satellite_id AS satellite_id_6, t0.series_id AS series_id_7 FROM SatelliteContent t0 WHERE t0.shopVideo_id = ?
Parameters:
[
  137
]
26 0.47 ms
SELECT t0.id AS id_1, t0.activateDate AS activateDate_2, t0.main AS main_3, t0.lastModified AS lastModified_4, t0.shopVideo_id AS shopVideo_id_5, t0.satellite_id AS satellite_id_6, t0.series_id AS series_id_7 FROM SatelliteContent t0 WHERE t0.shopVideo_id = ?
Parameters:
[
  126
]
27 0.58 ms
SELECT t0.id AS id_1, t0.activateDate AS activateDate_2, t0.main AS main_3, t0.lastModified AS lastModified_4, t0.shopVideo_id AS shopVideo_id_5, t0.satellite_id AS satellite_id_6, t0.series_id AS series_id_7 FROM SatelliteContent t0 WHERE t0.shopVideo_id = ?
Parameters:
[
  125
]
28 0.35 ms
SELECT t0.id AS id_1, t0.activateDate AS activateDate_2, t0.main AS main_3, t0.lastModified AS lastModified_4, t0.shopVideo_id AS shopVideo_id_5, t0.satellite_id AS satellite_id_6, t0.series_id AS series_id_7 FROM SatelliteContent t0 WHERE t0.shopVideo_id = ?
Parameters:
[
  123
]
29 0.37 ms
SELECT t0.id AS id_1, t0.activateDate AS activateDate_2, t0.main AS main_3, t0.lastModified AS lastModified_4, t0.shopVideo_id AS shopVideo_id_5, t0.satellite_id AS satellite_id_6, t0.series_id AS series_id_7 FROM SatelliteContent t0 WHERE t0.shopVideo_id = ?
Parameters:
[
  18
]
30 0.37 ms
SELECT t0.id AS id_1, t0.activateDate AS activateDate_2, t0.main AS main_3, t0.lastModified AS lastModified_4, t0.shopVideo_id AS shopVideo_id_5, t0.satellite_id AS satellite_id_6, t0.series_id AS series_id_7 FROM SatelliteContent t0 WHERE t0.shopVideo_id = ?
Parameters:
[
  103
]
31 0.35 ms
SELECT t0.id AS id_1, t0.activateDate AS activateDate_2, t0.main AS main_3, t0.lastModified AS lastModified_4, t0.shopVideo_id AS shopVideo_id_5, t0.satellite_id AS satellite_id_6, t0.series_id AS series_id_7 FROM SatelliteContent t0 WHERE t0.shopVideo_id = ?
Parameters:
[
  99
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

0 Hits
29 Misses
29 Puts

Number of cache misses

Region Misses
cache_shop_video 29

Number of cache puts

Region Puts
cache_shop_video 29

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\SatelliteContent 48
App\Entity\ShopVideo 24
App\Entity\Satellite 6
App\Entity\Series 4

Entities Mapping