| 1 |
0.97 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 = ?
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 = '66316';
|
| 2 |
0.80 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
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 = 'en' LIMIT 1;
|
| 3 |
958.72 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
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;
|
| 4 |
3.62 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 = ?
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 = 66316;
|
| 5 |
0.94 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 = ?
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 = 99353;
|
| 6 |
1.11 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 = ?
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 = 226;
|
| 7 |
0.75 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 = ?
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 = 226;
|
| 8 |
0.74 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 = ?
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 = 66316;
|
| 9 |
0.74 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 = ?
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 = 66316;
|
| 10 |
0.74 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 = ?
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 = 99354;
|