(Credit: Crave UK)
Only yesterday we were complaining that the Palm Centro didn't have enough oomph for our liking when--whaddaya know?--the postman kindly delivered Garmin's Mobile 10, a memory card and sat-nav receiver combo that converts a variety of smartphones, including the Centro, into satellite navigation devices....
]]>| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | DESCRIBE `tags` | 2 | 2 | 0 | |
| 2 | DESCRIBE `articles` | 12 | 12 | 1 | |
| 3 | DESCRIBE `articles_tags` | 2 | 2 | 0 | |
| 4 | SELECT `Tag`.`id`, `Tag`.`tag` FROM `tags` AS `Tag` WHERE `Tag`.`tag` = 'Garmin' 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` = 47 AND `articles_tags`.`article_id` = `Article`.`id`) WHERE 1 = 1 ORDER BY `Article`.`created` DESC | 1 | 1 | 2 | |
| 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`=47 | 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`=47 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` = 986 LIMIT 1 | 1 | 1 | 0 | |
| 9 | SELECT `Tag`.`id`, `Tag`.`tag` FROM `tags` AS `Tag` JOIN `articles_tags` ON (`articles_tags`.`article_id` = 986 AND `articles_tags`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 | 3 | 3 | 0 |