Smartphones and 3G data services are changing the way some people work, allowing them to access documents and applications from anywhere. But ...
]]>Smartphones and 3G data services are changing the way some people work, allowing them to access documents and applications from anywhere. But ...
]]>| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | DESCRIBE `tags` | 2 | 2 | 0 | |
| 2 | DESCRIBE `articles` | 12 | 12 | 0 | |
| 3 | DESCRIBE `articles_tags` | 2 | 2 | 0 | |
| 4 | SELECT `Tag`.`id`, `Tag`.`tag` FROM `tags` AS `Tag` WHERE `Tag`.`tag` = 'rumors' LIMIT 1 | 1 | 1 | 9 | |
| 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` = 43 AND `articles_tags`.`article_id` = `Article`.`id`) WHERE 1 = 1 ORDER BY `Article`.`created` DESC | 1 | 1 | 0 | |
| 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`=43 | 1 | 1 | 1 | |
| 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`=43 ORDER BY `created` DESC LIMIT 10 | 1 | 1 | 2 | |
| 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` = 977 LIMIT 1 | 1 | 1 | 2 | |
| 9 | SELECT `Tag`.`id`, `Tag`.`tag` FROM `tags` AS `Tag` JOIN `articles_tags` ON (`articles_tags`.`article_id` = 977 AND `articles_tags`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 | 3 | 3 | 1 |