Query Metrics
13
Database Queries
4
Different statements
4.64 ms
Query time
0
Invalid entities
30
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
2.93 ms (63.22%) |
10 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.legacy_id AS legacy_id_4, t0.audience AS audience_5, t0.url AS url_6, t0.affiliate_site_legacy_id AS affiliate_site_legacy_id_7, t0.active AS active_8 FROM studios t0 INNER JOIN movie_studios ON t0.id = movie_studios.studio_id WHERE movie_studios.movie_id = ?
Parameters:
[
7
]
|
||||||||||||||||||||||||||
|
0.69 ms (14.78%) |
1 |
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.slug AS slug_2, s0_.description AS description_3, s0_.audience AS audience_4, s0_.duration_seconds AS duration_seconds_5, s0_.release_date AS release_date_6, s0_.active AS active_7, s0_.studio_id AS studio_id_8 FROM scenes s0_ WHERE s0_.active = 1 AND s0_.audience IN (?, ?) ORDER BY s0_.release_date DESC, s0_.id DESC LIMIT 24
Parameters:
[ "gay" "both" ]
|
||||||||||||||||||||||||||
|
0.55 ms (11.96%) |
1 |
SELECT p0_.id AS id_0, p0_.main_name AS main_name_1, p0_.slug AS slug_2, p0_.legacy_id AS legacy_id_3, p0_.audience AS audience_4, p0_.birth_date AS birth_date_5, p0_.height AS height_6, p0_.weight AS weight_7, p0_.hair AS hair_8, p0_.eyes AS eyes_9, p0_.ethnicity AS ethnicity_10, p0_.biography AS biography_11, p0_.gender AS gender_12, p0_.twitter AS twitter_13, p0_.flirt4free AS flirt4free_14, p0_.chaturbate AS chaturbate_15, p0_.active AS active_16 FROM performers p0_ WHERE p0_.active = 1 AND p0_.audience IN (?, ?) ORDER BY p0_.main_name ASC LIMIT 12
Parameters:
[ "gay" "both" ]
|
||||||||||||||||||||||||||
|
0.47 ms (10.05%) |
1 |
SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.slug AS slug_2, m0_.legacy_id AS legacy_id_3, m0_.aebn_id AS aebn_id_4, m0_.description AS description_5, m0_.audience AS audience_6, m0_.release_date AS release_date_7, m0_.runtime_minutes AS runtime_minutes_8, m0_.active AS active_9 FROM movies m0_ WHERE m0_.active = 1 AND m0_.audience IN (?, ?) ORDER BY m0_.release_date DESC, m0_.id DESC LIMIT 24
Parameters:
[ "gay" "both" ]
|
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\Performer | 12 |
| App\Entity\Movie | 10 |
| App\Entity\Studio | 8 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Scene | No errors. |
| App\Entity\Studio | No errors. |
| App\Entity\Movie | No errors. |
| App\Entity\Series | No errors. |
| App\Entity\MovieScene | No errors. |
| App\Entity\PerformerNameCredit | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\Director | No errors. |
| App\Entity\MovieLink | No errors. |
| App\Entity\Performer | No errors. |
| App\Entity\PerformerBiography | No errors. |