| 1 |
0.52 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 = '2';
|
| 2 |
1.41 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
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 = 2 ORDER BY a0_.id DESC LIMIT 9;
|
| 3 |
0.60 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 = 2 ORDER BY a0_.id DESC) dctrn_result) dctrn_table;
|
| 4 |
0.21 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 = 929;
|
| 5 |
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 = 923;
|
| 6 |
0.21 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 = 914;
|
| 7 |
0.18 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 = 889;
|
| 8 |
0.19 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 = 882;
|
| 9 |
0.19 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 = 868;
|
| 10 |
0.19 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 = 864;
|
| 11 |
0.18 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 = 861;
|
| 12 |
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 = 855;
|
| 13 |
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
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.16 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.19 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;
|