GET https://newvirtualrealityporn.com/

Query Metrics

29 Database Queries
10 Different statements
14.66 ms Query time
0 Invalid entities
113 Managed entities

Grouped Statements

Show all queries

Time Count Info
4.02 ms
(27.43%)
8
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 INNER JOIN video_model ON t0.id = video_model.video_id WHERE video_model.model_id = ?
Parameters:
[
  18
]
3.70 ms
(25.26%)
6
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.sort_order AS sort_order_6, t0.featured AS featured_7, t0.short_description AS short_description_8, t0.description AS description_9 FROM category t0 INNER JOIN video_category ON t0.id = video_category.category_id WHERE video_category.video_id = ?
Parameters:
[
  9
]
2.52 ms
(17.19%)
6
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 WHERE t0.studio_id = ?
Parameters:
[
  1
]
1.17 ms
(8.00%)
3
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.sort_order AS sort_order_6, t0.description AS description_7, t0.cos_address AS cos_address_8, t0.country AS country_9, t0.founded AS founded_10 FROM studio t0 WHERE t0.id = ?
Parameters:
[
  9
]
0.76 ms
(5.17%)
1
SELECT COUNT(*) FROM video t0 WHERE t0.active = ?
Parameters:
[
  1
]
0.59 ms
(4.00%)
1
SELECT COUNT(*) FROM studio t0 WHERE t0.active = ?
Parameters:
[
  1
]
0.56 ms
(3.79%)
1
SELECT COUNT(*) FROM model t0 WHERE t0.active = ?
Parameters:
[
  1
]
0.50 ms
(3.40%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.sort_order AS sort_order_6, t0.date_of_birth AS date_of_birth_7, t0.nationality AS nationality_8, t0.gender AS gender_9, t0.ethnicity AS ethnicity_10, t0.hair_color AS hair_color_11, t0.eye_color AS eye_color_12, t0.height AS height_13, t0.weight AS weight_14, t0.measurements_hip AS measurements_hip_15, t0.measurements_waist AS measurements_waist_16, t0.measurements_bust AS measurements_bust_17, t0.shoe_size AS shoe_size_18, t0.description AS description_19, t0.views AS views_20 FROM model t0 WHERE t0.active = ? ORDER BY t0.id DESC LIMIT 8
Parameters:
[
  1
]
0.44 ms
(3.02%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 ORDER BY t0.release_date DESC, t0.id DESC LIMIT 6
Parameters:
[]
0.40 ms
(2.74%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.sort_order AS sort_order_6, t0.description AS description_7, t0.cos_address AS cos_address_8, t0.country AS country_9, t0.founded AS founded_10 FROM studio t0 WHERE t0.active = ? LIMIT 6
Parameters:
[
  1
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Category 87
App\Entity\Video 9
App\Entity\Studio 9
App\Entity\Model 8

Entities Mapping

Class Mapping errors
App\Entity\Video No errors.
App\Entity\Model No errors.
App\Entity\Studio No errors.
App\Entity\Category No errors.