邽赲 郇郋赲郋迮邿
2009: 迮赲訄郅2008: 邾訄訄郈迮郅26.01.09
郋邾郈訄郇邽 苳邽郇郕迮迡邽郇赲迮 郈迮迡郅訄迣訄迮 郅迣邽 郈郋 赲郋郱赲訄 迡郋郅迣郋赲 邽迡邽迮郕邽 郅邽
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | DESCRIBE `posts` | 7 | 7 | 24 | |
| 2 | SET NAMES 'UTF8' | 0 | 6 | ||
| 3 | DESCRIBE `settings` | 5 | 5 | 16 | |
| 4 | DESCRIBE `form_types` | 11 | 11 | 16 | |
| 5 | DESCRIBE `forms` | 12 | 12 | 16 | |
| 6 | DESCRIBE `locations` | 3 | 3 | 15 | |
| 7 | DESCRIBE `buyer_types` | 13 | 13 | 18 | |
| 8 | SELECT `Setting`.`id`, `Setting`.`icq`, `Setting`.`maintext`, `Setting`.`phone`, `Setting`.`email` FROM `settings` AS `Setting` WHERE `Setting`.`id` = 1 LIMIT 1 | 1 | 1 | 1 | |
| 9 | SELECT `FormType`.`id`, `FormType`.`name` FROM `form_types` AS `FormType` WHERE 1 = 1 | 10 | 10 | 0 | |
| 10 | SELECT `BuyerType`.`id`, `BuyerType`.`name` FROM `buyer_types` AS `BuyerType` WHERE 1 = 1 | 6 | 6 | 1 | |
| 11 | SELECT `Post`.`id`, `Post`.`name`, `Post`.`description`, `Post`.`content`, `Post`.`visible`, `Post`.`created`, `Post`.`modified` FROM `posts` AS `Post` WHERE visible ORDER BY `created` DESC LIMIT 2 | 2 | 2 | 1 | |
| 12 | SELECT `Post`.`id`, `Post`.`name`, `Post`.`description`, `Post`.`content`, `Post`.`visible`, `Post`.`created`, `Post`.`modified` FROM `posts` AS `Post` WHERE visible=1 AND created > "2009-0-00 00:00:00" AND created < "2009-12-00 00:00:00" ORDER BY `created` DESC | 1 | 1 | 1 | |
| 13 | SELECT DISTINCT EXTRACT( YEAR FROM created ) AS year FROM `posts` Post ORDER BY year DESC | 2 | 2 | 1 | |
| 14 | SELECT DISTINCT EXTRACT( MONTH FROM created ) AS month FROM `posts` Post WHERE EXTRACT( YEAR FROM created ) = 2009 ORDER BY month ASC | 1 | 1 | 2 | |
| 15 | SELECT DISTINCT EXTRACT( MONTH FROM created ) AS month FROM `posts` Post WHERE EXTRACT( YEAR FROM created ) = 2008 ORDER BY month ASC | 2 | 2 | 1 |
300186061