| 1 |
0.69 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.category AS category_4, t0.content AS content_5, t0.summary AS summary_6, t0.cover_image AS cover_image_7, t0.code_video AS code_video_8, t0.is_published AS is_published_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.author_id AS author_id_12, t0.language_code AS language_code_13, t0.translation_of_id AS translation_of_id_14 FROM tutorial_guide t0 WHERE t0.slug = ? LIMIT 1
Parameters: [
"where-winds-meet-how-to-start-well"
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.category AS category_4, t0.content AS content_5, t0.summary AS summary_6, t0.cover_image AS cover_image_7, t0.code_video AS code_video_8, t0.is_published AS is_published_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.author_id AS author_id_12, t0.language_code AS language_code_13, t0.translation_of_id AS translation_of_id_14 FROM tutorial_guide t0 WHERE t0.slug = 'where-winds-meet-how-to-start-well' LIMIT 1;
|
| 2 |
0.77 ms |
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.slug AS slug_2, t0_.category AS category_3, t0_.content AS content_4, t0_.summary AS summary_5, t0_.cover_image AS cover_image_6, t0_.code_video AS code_video_7, t0_.is_published AS is_published_8, t0_.created_at AS created_at_9, t0_.updated_at AS updated_at_10, t0_.author_id AS author_id_11, t0_.language_code AS language_code_12, t0_.translation_of_id AS translation_of_id_13 FROM tutorial_guide t0_ INNER JOIN sys_language s1_ ON t0_.language_code = s1_.code WHERE t0_.is_published = ? AND s1_.code = ? ORDER BY t0_.created_at DESC
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.slug AS slug_2, t0_.category AS category_3, t0_.content AS content_4, t0_.summary AS summary_5, t0_.cover_image AS cover_image_6, t0_.code_video AS code_video_7, t0_.is_published AS is_published_8, t0_.created_at AS created_at_9, t0_.updated_at AS updated_at_10, t0_.author_id AS author_id_11, t0_.language_code AS language_code_12, t0_.translation_of_id AS translation_of_id_13 FROM tutorial_guide t0_ INNER JOIN sys_language s1_ ON t0_.language_code = s1_.code WHERE t0_.is_published = 1 AND s1_.code = 'en' ORDER BY t0_.created_at DESC;
|
| 3 |
0.51 ms |
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.slug AS slug_2, t0_.category AS category_3, t0_.content AS content_4, t0_.summary AS summary_5, t0_.cover_image AS cover_image_6, t0_.code_video AS code_video_7, t0_.is_published AS is_published_8, t0_.created_at AS created_at_9, t0_.updated_at AS updated_at_10, t0_.author_id AS author_id_11, t0_.language_code AS language_code_12, t0_.translation_of_id AS translation_of_id_13 FROM tutorial_guide t0_ INNER JOIN sys_language s1_ ON t0_.language_code = s1_.code WHERE t0_.is_published = ? AND t0_.category = ? AND t0_.id <> ? AND s1_.code = ? ORDER BY t0_.created_at DESC LIMIT 3
Parameters: [
1
"beginner_guide"
1
"en"
]
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.slug AS slug_2, t0_.category AS category_3, t0_.content AS content_4, t0_.summary AS summary_5, t0_.cover_image AS cover_image_6, t0_.code_video AS code_video_7, t0_.is_published AS is_published_8, t0_.created_at AS created_at_9, t0_.updated_at AS updated_at_10, t0_.author_id AS author_id_11, t0_.language_code AS language_code_12, t0_.translation_of_id AS translation_of_id_13 FROM tutorial_guide t0_ INNER JOIN sys_language s1_ ON t0_.language_code = s1_.code WHERE t0_.is_published = 1 AND t0_.category = 'beginner_guide' AND t0_.id <> 1 AND s1_.code = 'en' ORDER BY t0_.created_at DESC LIMIT 3;
|
| 4 |
0.50 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.username AS username_5, t0.avatar AS avatar_6, t0.created_at AS created_at_7, t0.is_verified AS is_verified_8, t0.verification_token AS verification_token_9 FROM member_user t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.username AS username_5, t0.avatar AS avatar_6, t0.created_at AS created_at_7, t0.is_verified AS is_verified_8, t0.verification_token AS verification_token_9 FROM member_user t0 WHERE t0.id = 1;
|
| 5 |
0.37 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.category AS category_4, t0.content AS content_5, t0.summary AS summary_6, t0.cover_image AS cover_image_7, t0.code_video AS code_video_8, t0.is_published AS is_published_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.author_id AS author_id_12, t0.language_code AS language_code_13, t0.translation_of_id AS translation_of_id_14 FROM tutorial_guide t0 WHERE t0.translation_of_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.category AS category_4, t0.content AS content_5, t0.summary AS summary_6, t0.cover_image AS cover_image_7, t0.code_video AS code_video_8, t0.is_published AS is_published_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.author_id AS author_id_12, t0.language_code AS language_code_13, t0.translation_of_id AS translation_of_id_14 FROM tutorial_guide t0 WHERE t0.translation_of_id = 1;
|