GET https://newvirtualrealityporn.com/

Query Metrics

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

Queries

Group similar statements

# Time Info
1 4.81 ms
SELECT COUNT(*) FROM video t0 WHERE t0.active = ?
Parameters:
[
  1
]
2 0.94 ms
SELECT COUNT(*) FROM model t0 WHERE t0.active = ?
Parameters:
[
  1
]
3 0.84 ms
SELECT COUNT(*) FROM studio t0 WHERE t0.active = ?
Parameters:
[
  1
]
4 0.59 ms
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:
[]
5 0.68 ms
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
]
6 0.52 ms
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
]
7 1.26 ms
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
]
8 0.55 ms
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
]
9 0.63 ms
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:
[
  8
]
10 0.45 ms
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:
[
  8
]
11 0.65 ms
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:
[
  7
]
12 0.45 ms
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:
[
  7
]
13 0.63 ms
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:
[
  6
]
14 0.77 ms
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:
[
  5
]
15 0.80 ms
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:
[
  4
]
16 0.85 ms
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
]
17 0.56 ms
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:
[
  17
]
18 0.58 ms
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:
[
  16
]
19 0.69 ms
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:
[
  15
]
20 0.61 ms
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:
[
  14
]
21 0.56 ms
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:
[
  13
]
22 0.56 ms
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:
[
  12
]
23 0.57 ms
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:
[
  11
]
24 0.55 ms
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
]
25 0.52 ms
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:
[
  2
]
26 0.61 ms
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:
[
  3
]
27 0.52 ms
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:
[
  4
]
28 0.51 ms
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:
[
  5
]
29 0.52 ms
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:
[
  6
]

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.