GET https://justgayindex.com/movies/everyone-gets-a-go

Query Metrics

18 Database Queries
8 Different statements
5.18 ms Query time
0 Invalid entities
58 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
2.48 ms
(47.87%)
11
SELECT t0.id AS id_1, t0.main_name AS main_name_2, t0.slug AS slug_3, t0.legacy_id AS legacy_id_4, t0.audience AS audience_5, t0.birth_date AS birth_date_6, t0.height AS height_7, t0.weight AS weight_8, t0.hair AS hair_9, t0.eyes AS eyes_10, t0.ethnicity AS ethnicity_11, t0.biography AS biography_12, t0.gender AS gender_13, t0.twitter AS twitter_14, t0.flirt4free AS flirt4free_15, t0.chaturbate AS chaturbate_16, t0.active AS active_17 FROM performers t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.72 ms
(13.95%)
1
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:
[
  3
]
0.48 ms
(9.27%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.legacy_id AS legacy_id_4, t0.aebn_id AS aebn_id_5, t0.description AS description_6, t0.audience AS audience_7, t0.release_date AS release_date_8, t0.runtime_minutes AS runtime_minutes_9, t0.active AS active_10 FROM movies t0 WHERE t0.slug = ? AND t0.active = ? LIMIT 1
Parameters:
[
  "everyone-gets-a-go"
  1
]
0.43 ms
(8.26%)
1
SELECT t0.id AS id_1, t0.display_name AS display_name_2, t0.normalized_name AS normalized_name_3, t0.source_type AS source_type_4, t0.source_id AS source_id_5, t0.external_aebn_id AS external_aebn_id_6, t0.image_path AS image_path_7, t0.image_source AS image_source_8, t0.image_url AS image_url_9, t0.image_site_id AS image_site_id_10, t0.performer_id AS performer_id_11 FROM performer_name_credits t0 INNER JOIN movie_credits ON t0.id = movie_credits.performer_name_credit_id WHERE movie_credits.movie_id = ?
Parameters:
[
  3
]
0.33 ms
(6.32%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.legacy_id AS legacy_id_4, t0.aebn_id AS aebn_id_5, t0.type_code AS type_code_6, t0.audience AS audience_7, t0.active AS active_8 FROM categories t0 INNER JOIN movie_categories ON t0.id = movie_categories.category_id WHERE movie_categories.movie_id = ?
Parameters:
[
  3
]
0.26 ms
(5.08%)
1
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.active AS active_6 FROM series t0 INNER JOIN movie_series ON t0.id = movie_series.series_id WHERE movie_series.movie_id = ?
Parameters:
[
  3
]
0.25 ms
(4.85%)
1
SELECT t0.id AS id_1, t0.position AS position_2, t0.track_label AS track_label_3, t0.movie_id AS movie_id_4, t0.scene_id AS scene_id_5 FROM movie_scenes t0 WHERE t0.movie_id = ? ORDER BY t0.position ASC
Parameters:
[
  3
]
0.23 ms
(4.40%)
1
SELECT t0.id AS id_1, t0.label AS label_2, t0.url AS url_3, t0.price_label AS price_label_4, t0.movie_id AS movie_id_5, t0.affiliate_site_id AS affiliate_site_id_6 FROM movie_links t0 WHERE t0.movie_id = ?
Parameters:
[
  3
]

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\PerformerNameCredit 38
App\Entity\Performer 11
App\Entity\Category 7
App\Entity\Movie 1
App\Entity\Studio 1

Entities Mapping

Class Mapping errors
App\Entity\Movie No errors.
App\Entity\Studio 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\AffiliateSite No errors.
App\Entity\Performer No errors.
App\Entity\PerformerBiography No errors.
App\Entity\Scene No errors.