GET https://dollypass.netperv.com/

Query Metrics

25 Database Queries
2 Different statements
10.81 ms Query time
0 Invalid entities
82 Managed entities
5 Cache hits
24 Cache misses
24 Cache puts

Queries

Group similar statements

# Time Info
1 0.97 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 0.50 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
]
3 0.52 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
]
4 0.40 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
]
5 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:
[
  95
]
6 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:
[
  98
]
7 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:
[
  87
]
8 0.39 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
]
9 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:
[
  135
]
10 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:
[
  119
]
11 0.39 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
]
12 0.38 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
]
13 0.40 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
]
14 0.39 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
]
15 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:
[
  107
]
16 0.41 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
]
17 0.39 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
]
18 0.38 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
]
19 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:
[
  137
]
20 0.39 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
]
21 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:
[
  125
]
22 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:
[
  123
]
23 0.39 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
]
24 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:
[
  103
]
25 0.32 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

5 Hits
24 Misses
24 Puts

Number of cache hits

Region Hits
cache_shop_video 5

Number of cache misses

Region Misses
cache_shop_video 24

Number of cache puts

Region Puts
cache_shop_video 24

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