| Query | Error | Affected | Num. rows | Took (ms) | Actions |
|---|
| UPDATE `items` AS `Item` LEFT JOIN `item_rubrics` AS `ItemRubric` ON (`Item`.`item_rubric_id` = `ItemRubric`.`id`) LEFT JOIN `brands` AS `Brand` ON (`Item`.`brand_id` = `Brand`.`id`) SET `Item`.`drop_new` = 0, `Item`.`new` = 0 WHERE `drop_new` = 1 AND `new_time` <= '2012-01-28 11:03:18' | | 0 | | 1 | maybe slow |
| SELECT `StaticPage`.`id`, `StaticPage`.`url`, `StaticPage`.`route`, `StaticPage`.`caption`, `StaticPage`.`content`, `StaticPage`.`note`, `StaticPage`.`created`, `StaticPage`.`modified` FROM `static_pages` AS `StaticPage` WHERE ((`StaticPage`.`url` = '/') OR (`StaticPage`.`route` = 'pages/mainpage')) ORDER BY `StaticPage`.`id` ASC LIMIT 1 | | 0 | 0 | 0 | |
| SELECT `UrlRule`.`id`, `UrlRule`.`url`, `UrlRule`.`disabled`, `UrlRule`.`note`, `UrlRule`.`created`, `UrlRule`.`modified` FROM `url_rules` AS `UrlRule` WHERE `UrlRule`.`disabled` = 0 AND `UrlRule`.`url` IN ('/', '*') AND `UrlRule`.`disabled` <> 1 ORDER BY `UrlRule`.`url` ASC, `UrlRule`.`id` ASC | | 1 | 1 | 0 | |
| SELECT `Page`.`id`, `Page`.`slug`, `Page`.`caption`, `Page`.`content`, `Page`.`meta_title`, `Page`.`meta_keywords`, `Page`.`meta_description`, `Page`.`disabled`, `Page`.`note`, `Page`.`created`, `Page`.`modified` FROM `pages` AS `Page` WHERE `Page`.`disabled` = 0 AND `Page`.`id` = 1 AND `Page`.`disabled` <> 1 ORDER BY `Page`.`id` ASC LIMIT 1 | | 1 | 1 | 0 | |
| SELECT `News`.`id`, `News`.`published`, `News`.`brief` FROM `news` AS `News` WHERE 1 = 1 ORDER BY `News`.`published` DESC, `News`.`id` DESC LIMIT 3 | | 3 | 3 | 0 | |
| SELECT `Item`.`id`, `Item`.`caption`, `Item`.`brief_on_main`, `Item`.`image_on_main` FROM `items` AS `Item` WHERE `Item`.`disabled` = 0 AND `on_main` = 1 AND `Item`.`disabled` <> 1 ORDER BY RAND() ASC | | 3 | 3 | 2 | maybe slow |
| SELECT `Setting`.`course` FROM `settings` AS `Setting` WHERE 1 = 1 ORDER BY `Setting`.`id` ASC LIMIT 1 | | 1 | 1 | 0 | |
| SELECT `Page`.`id`, `Page`.`slug`, `Page`.`caption`, `Page`.`content`, `Page`.`meta_title`, `Page`.`meta_keywords`, `Page`.`meta_description`, `Page`.`disabled`, `Page`.`note`, `Page`.`created`, `Page`.`modified` FROM `pages` AS `Page` WHERE `Page`.`disabled` = 0 AND `Page`.`id` = 1 AND `Page`.`disabled` <> 1 ORDER BY `Page`.`id` ASC LIMIT 1 | | 1 | 1 | 0 | |
| UPDATE `items` AS `Item` LEFT JOIN `item_rubrics` AS `ItemRubric` ON (`Item`.`item_rubric_id` = `ItemRubric`.`id`) LEFT JOIN `brands` AS `Brand` ON (`Item`.`brand_id` = `Brand`.`id`) SET `Item`.`drop_new` = 0, `Item`.`new` = 0 WHERE `drop_new` = 1 AND `new_time` <= '2012-01-28 11:03:18' | | 0 | | 1 | maybe slow |
| SELECT `StaticPage`.`id`, `StaticPage`.`url`, `StaticPage`.`route`, `StaticPage`.`caption`, `StaticPage`.`content`, `StaticPage`.`note`, `StaticPage`.`created`, `StaticPage`.`modified` FROM `static_pages` AS `StaticPage` WHERE ((`StaticPage`.`url` = '/banners/get3banner/divider:CorporateBanner') OR (`StaticPage`.`route` = 'banners/get3banner')) ORDER BY `StaticPage`.`id` ASC LIMIT 1 | | 0 | 0 | 0 | |
| SELECT `UrlRule`.`id`, `UrlRule`.`url`, `UrlRule`.`disabled`, `UrlRule`.`note`, `UrlRule`.`created`, `UrlRule`.`modified` FROM `url_rules` AS `UrlRule` WHERE `UrlRule`.`disabled` = 0 AND `UrlRule`.`url` IN ('/banners/get3banner/divider:CorporateBanner', '/banners/get3banner/*', '/banners/*', '/*', '*') AND `UrlRule`.`disabled` <> 1 ORDER BY `UrlRule`.`url` ASC, `UrlRule`.`id` ASC | | 1 | 1 | 0 | |
| SELECT `Banner`.`id`, `Banner`.`divider`, `Banner`.`title`, `Banner`.`url`, `Banner`.`image`, `Banner`.`flash`, `Banner`.`disabled`, `Banner`.`position` FROM `banners` AS `Banner` WHERE `Banner`.`disabled` = 0 AND `Banner`.`divider` = 'CorporateBanner' AND `Banner`.`divider` = 'CorporateBanner' AND `Banner`.`disabled` <> 1 ORDER BY `Banner`.`position` DESC LIMIT 3 | | 3 | 3 | 0 | |
| UPDATE `items` AS `Item` LEFT JOIN `item_rubrics` AS `ItemRubric` ON (`Item`.`item_rubric_id` = `ItemRubric`.`id`) LEFT JOIN `brands` AS `Brand` ON (`Item`.`brand_id` = `Brand`.`id`) SET `Item`.`drop_new` = 0, `Item`.`new` = 0 WHERE `drop_new` = 1 AND `new_time` <= '2012-01-28 11:03:18' | | 0 | | 1 | maybe slow |
| SELECT `News`.`id`, `News`.`published`, `News`.`brief` FROM `news` AS `News` WHERE 1 = 1 ORDER BY `News`.`published` DESC, `News`.`id` DESC LIMIT 3 | | 3 | 3 | 0 | |
| SELECT `Item`.`id`, `Item`.`caption`, `Item`.`brief_on_main`, `Item`.`image_on_main` FROM `items` AS `Item` WHERE `Item`.`disabled` = 0 AND `on_main` = 1 AND `Item`.`disabled` <> 1 ORDER BY RAND() ASC | | 3 | 3 | 2 | maybe slow |
| SELECT `Setting`.`course` FROM `settings` AS `Setting` WHERE 1 = 1 ORDER BY `Setting`.`id` ASC LIMIT 1 | | 1 | 1 | 0 | |
| SELECT `ContactItem`.`id`, `ContactItem`.`caption` FROM `contact_items` AS `ContactItem` WHERE 1 = 1 ORDER BY `ContactItem`.`position` DESC | | 4 | 4 | 0 | |
| SELECT `StaticPage`.`id`, `StaticPage`.`url`, `StaticPage`.`route`, `StaticPage`.`caption`, `StaticPage`.`content`, `StaticPage`.`note`, `StaticPage`.`created`, `StaticPage`.`modified` FROM `static_pages` AS `StaticPage` WHERE ((`StaticPage`.`url` = '/contact_items/getFirstID') OR (`StaticPage`.`route` = 'contact_items/getFirstID')) ORDER BY `StaticPage`.`id` ASC LIMIT 1 | | 0 | 0 | 0 | |
| SELECT `UrlRule`.`id`, `UrlRule`.`url`, `UrlRule`.`disabled`, `UrlRule`.`note`, `UrlRule`.`created`, `UrlRule`.`modified` FROM `url_rules` AS `UrlRule` WHERE `UrlRule`.`disabled` = 0 AND `UrlRule`.`url` IN ('/contact_items/getFirstID', '/contact_items/*', '/*', '*') AND `UrlRule`.`disabled` <> 1 ORDER BY `UrlRule`.`url` ASC, `UrlRule`.`id` ASC | | 1 | 1 | 0 | |
| SELECT `ContactItem`.`id` FROM `contact_items` AS `ContactItem` WHERE 1 = 1 ORDER BY `ContactItem`.`position` DESC LIMIT 1 | | 1 | 1 | 0 | |
| UPDATE `items` AS `Item` LEFT JOIN `item_rubrics` AS `ItemRubric` ON (`Item`.`item_rubric_id` = `ItemRubric`.`id`) LEFT JOIN `brands` AS `Brand` ON (`Item`.`brand_id` = `Brand`.`id`) SET `Item`.`drop_new` = 0, `Item`.`new` = 0 WHERE `drop_new` = 1 AND `new_time` <= '2012-01-28 11:03:18' | | 0 | | 1 | maybe slow |
| SELECT `StaticPage`.`id`, `StaticPage`.`url`, `StaticPage`.`route`, `StaticPage`.`caption`, `StaticPage`.`content`, `StaticPage`.`note`, `StaticPage`.`created`, `StaticPage`.`modified` FROM `static_pages` AS `StaticPage` WHERE ((`StaticPage`.`url` = '/comunicator/index/operator:4') OR (`StaticPage`.`route` = 'comunicator/index')) ORDER BY `StaticPage`.`id` ASC LIMIT 1 | | 0 | 0 | 0 | |
| SELECT `UrlRule`.`id`, `UrlRule`.`url`, `UrlRule`.`disabled`, `UrlRule`.`note`, `UrlRule`.`created`, `UrlRule`.`modified` FROM `url_rules` AS `UrlRule` WHERE `UrlRule`.`disabled` = 0 AND `UrlRule`.`url` IN ('/comunicator/index/operator:4', '/comunicator/index/*', '/comunicator/*', '/*', '*') AND `UrlRule`.`disabled` <> 1 ORDER BY `UrlRule`.`url` ASC, `UrlRule`.`id` ASC | | 1 | 1 | 0 | |
| SELECT `Operator`.`id`, `Operator`.`department`, `Operator`.`lo`, `Operator`.`forum_link`, `Operator`.`icq`, `Operator`.`skype`, `Operator`.`email`, `Operator`.`position` FROM `operators` AS `Operator` WHERE 1 = 1 ORDER BY `Operator`.`position` DESC | | 9 | 9 | 0 | |
ЗАО «ЭТИМ», 1991-2011.