Read More
Read more in mobile format
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | DESCRIBE `tags` | 2 | 2 | 57 | |
| 2 | DESCRIBE `articles` | 12 | 12 | 13 | |
| 3 | DESCRIBE `articles_tags` | 2 | 2 | 1 | |
| 4 | SELECT `Tag`.`id`, `Tag`.`tag` FROM `tags` AS `Tag` WHERE `Tag`.`tag` = 'GPS' LIMIT 1 | 1 | 1 | 1 | |
| 5 | SELECT `Article`.`id`, `Article`.`product_id`, `Article`.`title`, `Article`.`summary`, `Article`.`source`, `Article`.`url`, `Article`.`author`, `Article`.`rating`, `Article`.`rating_type`, `Article`.`status`, `Article`.`created`, `Article`.`modified` FROM `articles` AS `Article` JOIN `articles_tags` ON (`articles_tags`.`tag_id` = 35 AND `articles_tags`.`article_id` = `Article`.`id`) WHERE 1 = 1 ORDER BY `Article`.`created` DESC | 4 | 4 | 1 | |
| 6 | SELECT COUNT(*) AS `count` FROM `articles_tags` AS `ArticlesTag` LEFT JOIN `articles` AS `Article` ON (`ArticlesTag`.`article_id` = `Article`.`id`) LEFT JOIN `tags` AS `Tag` ON (`ArticlesTag`.`tag_id` = `Tag`.`id`) WHERE `Tag`.`id`=35 | 1 | 1 | 0 | |
| 7 | SELECT `ArticlesTag`.`article_id`, `ArticlesTag`.`tag_id`, `Article`.`id`, `Article`.`product_id`, `Article`.`title`, `Article`.`summary`, `Article`.`source`, `Article`.`url`, `Article`.`author`, `Article`.`rating`, `Article`.`rating_type`, `Article`.`status`, `Article`.`created`, `Article`.`modified`, `Tag`.`id`, `Tag`.`tag` FROM `articles_tags` AS `ArticlesTag` LEFT JOIN `articles` AS `Article` ON (`ArticlesTag`.`article_id` = `Article`.`id`) LEFT JOIN `tags` AS `Tag` ON (`ArticlesTag`.`tag_id` = `Tag`.`id`) WHERE `Tag`.`id`=35 ORDER BY `created` DESC LIMIT 10 | 4 | 4 | 1 | |
| 8 | SELECT `Article`.`id`, `Article`.`product_id`, `Article`.`title`, `Article`.`summary`, `Article`.`source`, `Article`.`url`, `Article`.`author`, `Article`.`rating`, `Article`.`rating_type`, `Article`.`status`, `Article`.`created`, `Article`.`modified` FROM `articles` AS `Article` WHERE `Article`.`id` = 963 LIMIT 1 | 1 | 1 | 1 | |
| 9 | SELECT `Tag`.`id`, `Tag`.`tag` FROM `tags` AS `Tag` JOIN `articles_tags` ON (`articles_tags`.`article_id` = 963 AND `articles_tags`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 | 3 | 3 | 0 | |
| 10 | SELECT `Article`.`id`, `Article`.`product_id`, `Article`.`title`, `Article`.`summary`, `Article`.`source`, `Article`.`url`, `Article`.`author`, `Article`.`rating`, `Article`.`rating_type`, `Article`.`status`, `Article`.`created`, `Article`.`modified` FROM `articles` AS `Article` WHERE `Article`.`id` = 1000 LIMIT 1 | 1 | 1 | 0 | |
| 11 | SELECT `Tag`.`id`, `Tag`.`tag` FROM `tags` AS `Tag` JOIN `articles_tags` ON (`articles_tags`.`article_id` = 1000 AND `articles_tags`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 | 4 | 4 | 0 | |
| 12 | SELECT `Article`.`id`, `Article`.`product_id`, `Article`.`title`, `Article`.`summary`, `Article`.`source`, `Article`.`url`, `Article`.`author`, `Article`.`rating`, `Article`.`rating_type`, `Article`.`status`, `Article`.`created`, `Article`.`modified` FROM `articles` AS `Article` WHERE `Article`.`id` = 1001 LIMIT 1 | 1 | 1 | 0 | |
| 13 | SELECT `Tag`.`id`, `Tag`.`tag` FROM `tags` AS `Tag` JOIN `articles_tags` ON (`articles_tags`.`article_id` = 1001 AND `articles_tags`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 | 3 | 3 | 0 | |
| 14 | SELECT `Article`.`id`, `Article`.`product_id`, `Article`.`title`, `Article`.`summary`, `Article`.`source`, `Article`.`url`, `Article`.`author`, `Article`.`rating`, `Article`.`rating_type`, `Article`.`status`, `Article`.`created`, `Article`.`modified` FROM `articles` AS `Article` WHERE `Article`.`id` = 971 LIMIT 1 | 1 | 1 | 0 | |
| 15 | SELECT `Tag`.`id`, `Tag`.`tag` FROM `tags` AS `Tag` JOIN `articles_tags` ON (`articles_tags`.`article_id` = 971 AND `articles_tags`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 | 3 | 3 | 1 |