0.55 ms (64.77%)
|
1 |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.featured_image AS featured_image_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p0_.post_at AS post_at_6, p0_.is_published AS is_published_7, c1_.id AS id_8, c1_.content AS content_9, c1_.created_at AS created_at_10, c1_.updated_at AS updated_at_11, c1_.is_approved AS is_approved_12, p0_.author_id AS author_id_13, p0_.updated_by_id AS updated_by_id_14, c1_.author_id AS author_id_15, c1_.post_id AS post_id_16, c1_.updated_by_id AS updated_by_id_17 FROM post p0_ LEFT JOIN comment c1_ ON p0_.id = c1_.post_id AND (c1_.is_approved = 1) WHERE p0_.id = ?
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.featured_image AS featured_image_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p0_.post_at AS post_at_6, p0_.is_published AS is_published_7, c1_.id AS id_8, c1_.content AS content_9, c1_.created_at AS created_at_10, c1_.updated_at AS updated_at_11, c1_.is_approved AS is_approved_12, p0_.author_id AS author_id_13, p0_.updated_by_id AS updated_by_id_14, c1_.author_id AS author_id_15, c1_.post_id AS post_id_16, c1_.updated_by_id AS updated_by_id_17 FROM post p0_ LEFT JOIN comment c1_ ON p0_.id = c1_.post_id AND (c1_.is_approved = 1) WHERE p0_.id = 12;
|
0.30 ms (35.23%)
|
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.is_active AS is_active_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11 FROM `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.first_name AS first_name_5, t0.last_name AS last_name_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.is_active AS is_active_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11 FROM `user` t0 WHERE t0.id = 13;
|