GET https://dev.bterra.org/quote/2418

Query Metrics

10 Database Queries
9 Different statements
823.60 ms Query time
0 Invalid entities
40 Managed entities

Queries

Group similar statements

default connection

# Time Info
1 1.37 ms
SELECT t0.id AS id_1, t0.sort_order AS sort_order_2, t0.type AS type_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.old_quote_id AS old_quote_id_7, t0.display_date AS display_date_8, t0.display_month AS display_month_9, t0.display_day AS display_day_10, t0.author_id AS author_id_11, t0.book_id AS book_id_12, t0.parent_quote_id AS parent_quote_id_13, t0.created_by_id AS created_by_id_14 FROM quote t0 WHERE t0.id = ?
Parameters:
[
  "2418"
]
2 1.01 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.native_name AS native_name_4 FROM language t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "en"
]
3 813.36 ms
SELECT l0_.id AS id_0, l0_.code AS code_1, l0_.name AS name_2, l0_.native_name AS native_name_3 FROM language l0_ INNER JOIN quote_translation q1_ ON (q1_.language_id = l0_.id) INNER JOIN quote q2_ ON q1_.quote_id = q2_.id WHERE q2_.deleted_at IS NULL GROUP BY l0_.id ORDER BY l0_.name ASC
Parameters:
[]
4 1.37 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.title AS title_3, t0.variant AS variant_4, t0.vote_score AS vote_score_5, t0.comment_count AS comment_count_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.quote_id AS quote_id_9, t0.language_id AS language_id_10, t0.book_translation_id AS book_translation_id_11, t0.translator_id AS translator_id_12 FROM quote_translation t0 WHERE t0.quote_id = ?
Parameters:
[
  2418
]
5 1.13 ms
SELECT t0.id AS id_1, t0.audio_path AS audio_path_2, t0.extension AS extension_3, t0.file_size AS file_size_4, t0.duration AS duration_5, t0.created_at AS created_at_6, t0.deleted_at AS deleted_at_7, t0.quote_translation_id AS quote_translation_id_8, t0.speaker_id AS speaker_id_9 FROM quote_audio t0 WHERE t0.quote_translation_id = ?
Parameters:
[
  13423
]
6 1.15 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.birth_date AS birth_date_5, t0.death_date AS death_date_6, t0.old_tag_id AS old_tag_id_7, t0.image_path AS image_path_8, t0.is_translator AS is_translator_9, t0.created_by_id AS created_by_id_10, t11.id AS id_12, t11.quote_translation_count AS quote_translation_count_13, t11.book_translation_count AS book_translation_count_14, t11.total_votes_received AS total_votes_received_15, t11.positive_votes_received AS positive_votes_received_16, t11.average_rating AS average_rating_17, t11.first_translation_date AS first_translation_date_18, t11.last_translation_date AS last_translation_date_19, t11.last_calculated_at AS last_calculated_at_20, t11.translator_id AS translator_id_21 FROM author t0 LEFT JOIN translator_statistics t11 ON t11.translator_id = t0.id WHERE t0.id = ?
Parameters:
[
  19
]
7 1.06 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.biography AS biography_3, t0.author_id AS author_id_4, t0.language_id AS language_id_5 FROM author_translation t0 WHERE t0.author_id = ?
Parameters:
[
  19
]
8 1.05 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.created_at AS created_at_3, t0.deleted_at AS deleted_at_4 FROM tag t0 INNER JOIN quote_tags ON t0.id = quote_tags.tag_id WHERE quote_tags.quote_id = ?
Parameters:
[
  2418
]
9 1.05 ms
SELECT t0.id AS id_1, t0.sort_order AS sort_order_2, t0.type AS type_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.old_quote_id AS old_quote_id_7, t0.display_date AS display_date_8, t0.display_month AS display_month_9, t0.display_day AS display_day_10, t0.author_id AS author_id_11, t0.book_id AS book_id_12, t0.parent_quote_id AS parent_quote_id_13, t0.created_by_id AS created_by_id_14 FROM quote t0 WHERE t0.parent_quote_id = ?
Parameters:
[
  2418
]
10 1.05 ms
SELECT t0.id AS id_1, t0.audio_path AS audio_path_2, t0.extension AS extension_3, t0.file_size AS file_size_4, t0.duration AS duration_5, t0.created_at AS created_at_6, t0.deleted_at AS deleted_at_7, t0.quote_translation_id AS quote_translation_id_8, t0.speaker_id AS speaker_id_9 FROM quote_audio t0 WHERE t0.quote_translation_id = ?
Parameters:
[
  13424
]

Database Connections

Name Service
default doctrine.dbal.default_connection
legacy doctrine.dbal.legacy_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\Language 33
App\Entity\QuoteTranslation 2
App\Entity\AuthorTranslation 2
App\Entity\Quote 1
App\Entity\Author 1
App\Entity\User 1

Entities Mapping

Class Mapping errors
App\Entity\Quote No errors.
App\Entity\Author No errors.
App\Entity\Book No errors.
App\Entity\User No errors.
App\Entity\QuoteTranslation No errors.
App\Entity\Tag No errors.
App\Entity\Language No errors.
App\Entity\BookTranslation No errors.
App\Entity\QuoteAudio No errors.
App\Entity\TranslatorStatistics No errors.
App\Entity\AuthorTranslation No errors.