| 1 |
0.47 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.parent_id AS parent_id_6 FROM category t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.parent_id AS parent_id_6 FROM category t0 WHERE t0.id = '4';
|
| 2 |
0.69 ms |
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.description AS description_2, a0_.publish_date AS publish_date_3, a0_.created_at AS created_at_4, a0_.publish AS publish_5, a0_.image AS image_6, a0_.author_id AS author_id_7 FROM article a0_ INNER JOIN article_category a2_ ON a0_.id = a2_.article_id INNER JOIN category c1_ ON c1_.id = a2_.category_id WHERE c1_.id = ? ORDER BY a0_.id DESC LIMIT 9 OFFSET 9
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.description AS description_2, a0_.publish_date AS publish_date_3, a0_.created_at AS created_at_4, a0_.publish AS publish_5, a0_.image AS image_6, a0_.author_id AS author_id_7 FROM article a0_ INNER JOIN article_category a2_ ON a0_.id = a2_.article_id INNER JOIN category c1_ ON c1_.id = a2_.category_id WHERE c1_.id = 4 ORDER BY a0_.id DESC LIMIT 9 OFFSET 9;
|
| 3 |
0.45 ms |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.description AS description_2, a0_.publish_date AS publish_date_3, a0_.created_at AS created_at_4, a0_.publish AS publish_5, a0_.image AS image_6 FROM article a0_ INNER JOIN article_category a2_ ON a0_.id = a2_.article_id INNER JOIN category c1_ ON c1_.id = a2_.category_id WHERE c1_.id = ? ORDER BY a0_.id DESC) dctrn_result) dctrn_table
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.description AS description_2, a0_.publish_date AS publish_date_3, a0_.created_at AS created_at_4, a0_.publish AS publish_5, a0_.image AS image_6 FROM article a0_ INNER JOIN article_category a2_ ON a0_.id = a2_.article_id INNER JOIN category c1_ ON c1_.id = a2_.category_id WHERE c1_.id = 4 ORDER BY a0_.id DESC) dctrn_result) dctrn_table;
|
| 4 |
0.20 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.parent_id AS parent_id_6 FROM category t0 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.parent_id AS parent_id_6 FROM category t0 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = 573;
|
| 5 |
0.17 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.parent_id AS parent_id_6 FROM category t0 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.parent_id AS parent_id_6 FROM category t0 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = 567;
|
| 6 |
0.15 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.parent_id AS parent_id_6 FROM category t0 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.parent_id AS parent_id_6 FROM category t0 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = 564;
|
| 7 |
0.15 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.parent_id AS parent_id_6 FROM category t0 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.parent_id AS parent_id_6 FROM category t0 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = 480;
|
| 8 |
0.14 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.parent_id AS parent_id_6 FROM category t0 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.parent_id AS parent_id_6 FROM category t0 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = 470;
|
| 9 |
0.14 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.parent_id AS parent_id_6 FROM category t0 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.parent_id AS parent_id_6 FROM category t0 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = 469;
|
| 10 |
0.14 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.parent_id AS parent_id_6 FROM category t0 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.parent_id AS parent_id_6 FROM category t0 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = 455;
|
| 11 |
0.14 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.parent_id AS parent_id_6 FROM category t0 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.parent_id AS parent_id_6 FROM category t0 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = 453;
|
| 12 |
0.13 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.parent_id AS parent_id_6 FROM category t0 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.parent_id AS parent_id_6 FROM category t0 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = 446;
|
| 13 |
0.12 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.parent_id AS parent_id_6 FROM category t0
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.parent_id AS parent_id_6 FROM category t0;
|
| 14 |
0.12 ms |
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.description AS description_2, a0_.publish_date AS publish_date_3, a0_.created_at AS created_at_4, a0_.publish AS publish_5, a0_.image AS image_6, a0_.author_id AS author_id_7 FROM article a0_ ORDER BY a0_.id DESC LIMIT 1
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.description AS description_2, a0_.publish_date AS publish_date_3, a0_.created_at AS created_at_4, a0_.publish AS publish_5, a0_.image AS image_6, a0_.author_id AS author_id_7 FROM article a0_ ORDER BY a0_.id DESC LIMIT 1;
|
| 15 |
0.15 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.parent_id AS parent_id_6 FROM category t0 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.parent_id AS parent_id_6 FROM category t0 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = 932;
|