Deprecated: Non-static method Router::url() should not be called statically, assuming $this from incompatible context in /home/distortion/revision/cake/libs/view/helper.php on line 178
Deprecated: Non-static method Router::getInstance() should not be called statically, assuming $this from incompatible context in /home/distortion/revision/cake/libs/router.php on line 756
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | DESCRIBE `do_news` | 5 | 5 | 1 | |
| 2 | DESCRIBE `do_menus` | 5 | 5 | 1 | |
| 3 | DESCRIBE `do_shows` | 7 | 7 | 1 | |
| 4 | SELECT `News`.`newsID`, `News`.`newsTime`, `News`.`newsText`, `News`.`newsPoster`, `News`.`newsTitle` FROM `do_news` AS `News` WHERE year(newsTime) = '2005' AND month(newsTime) = '09' ORDER BY `newsTime` DESC | 1 | 1 | 1 | |
| 5 | SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`name`, `Menu`.`h_link`, `Menu`.`type` FROM `do_menus` AS `Menu` WHERE 1 = 1 ORDER BY `id` ASC | 40 | 40 | 1 | |
| 6 | SELECT year(newsTime) as year, month(newsTime) as month, count(*) as count FROM `do_news` AS `News` WHERE 1 = 1 GROUP BY month, year ORDER BY `year` DESC, `month` DESC | 31 | 31 | 1 | |
| 7 | SELECT year(date) as year, count(*) as count FROM `do_shows` AS `Shows` WHERE 1 = 1 GROUP BY year(date) | 13 | 13 | 1 |
Shop Amazon.com