Query Metrics
3
Database Queries
3
Different statements
2.36 ms
Query time
0
Invalid entities
54
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.92 ms |
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 5000
Parameters:
[ "gay" "both" ]
|
||||||||||||||||||||||||||
| 2 | 0.83 ms |
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 5000
Parameters:
[ "gay" "both" ]
|
||||||||||||||||||||||||||
| 3 | 0.62 ms |
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 5000
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 | 44 |
| App\Entity\Movie | 10 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Scene | No errors. |
| App\Entity\Studio | No errors. |
| App\Entity\Performer | No errors. |
| App\Entity\PerformerNameCredit | No errors. |
| App\Entity\PerformerBiography | No errors. |
| App\Entity\Movie | No errors. |
| App\Entity\Series | No errors. |
| App\Entity\MovieScene | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\Director | No errors. |
| App\Entity\MovieLink | No errors. |