GET https://justgayindex.com/

Query Metrics

13 Database Queries
4 Different statements
4.77 ms Query time
0 Invalid entities
30 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
3.03 ms
(63.42%)
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.56%)
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.54 ms
(11.37%)
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.51 ms
(10.66%)
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.