2012-02-06 23:09:33







39 queries took 1 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `aros`550
2DESCRIBE `aros_acos`770
3DESCRIBE `acos`550
4SELECT `sessions`.`data` FROM `sessions` WHERE `sessions`.`id` = '8d9d1ecd691ce6b5aaac9b947018afd7'110
5DESCRIBE `config`440
6DESCRIBE `category`990
7DESCRIBE `sub`550
8DESCRIBE `sub2`660
9DESCRIBE `news`13130
10DESCRIBE `news_text`330
11DESCRIBE `news_image`440
12DESCRIBE `comment`13130
13DESCRIBE `admin`330
14DESCRIBE `mod`660
15DESCRIBE `break_news`220
16DESCRIBE `temp_news`770
17DESCRIBE `poll`20201
18DESCRIBE `ads_zone`660
19DESCRIBE `ads_banner`15150
20DESCRIBE `section`550
21SELECT `Category`.`cat_id`, `Category`.`cat_name`, `Category`.`cat_name_en`, `Category`.`description`, `Category`.`css`, `Category`.`visible`, `Category`.`ord`, `Category`.`main_news_id`, `Category`.`show` FROM `category` AS `Category` WHERE 1 = 1 ORDER BY `ord` ASC 14140
22SELECT `Sub`.`sub_id`, `Sub`.`cat_id`, `Sub`.`sub_name`, `Sub`.`description`, `Sub`.`main_news_id` FROM `sub` AS `Sub` WHERE `Sub`.`cat_id` IN (1, 2, 7, 8, 9, 10, 12, 14, 18, 13, 16, 15, 17, 11) 330
23SELECT `News`.`news_id`, `News`.`title` FROM `news` AS `News` LEFT JOIN `news_text` AS `News_text` ON (`News_text`.`news_id` = `News`.`news_id`) WHERE 1 = 1 ORDER BY `News`.`read_per_week` DESC LIMIT 5550
24SELECT `Ads_zone`.`zone_id`, `Ads_zone`.`name`, `Ads_zone`.`description`, `Ads_zone`.`type`, `Ads_zone`.`break`, `Ads_zone`.`active` FROM `ads_zone` AS `Ads_zone` WHERE `Ads_zone`.`active`='1' 440
25SELECT `Ads_banner`.`banner_id`, `Ads_banner`.`zone_id`, `Ads_banner`.`layout`, `Ads_banner`.`cat_id`, `Ads_banner`.`sub_id`, `Ads_banner`.`sub2_id`, `Ads_banner`.`name`, `Ads_banner`.`type`, `Ads_banner`.`filename`, `Ads_banner`.`width`, `Ads_banner`.`height`, `Ads_banner`.`url`, `Ads_banner`.`alt`, `Ads_banner`.`weight`, `Ads_banner`.`active`, `Ads_zone`.`zone_id`, `Ads_zone`.`name`, `Ads_zone`.`description`, `Ads_zone`.`type`, `Ads_zone`.`break`, `Ads_zone`.`active` FROM `ads_banner` AS `Ads_banner` LEFT JOIN `ads_zone` AS `Ads_zone` ON (`Ads_banner`.`zone_id` = `Ads_zone`.`zone_id`) WHERE `Ads_banner`.`zone_id`='1' and `Ads_banner`.`layout`='global' and `Ads_banner`.`cat_id`='-1' and `Ads_banner`.`sub_id`='-1' and `Ads_banner`.`sub2_id`='-1' and `Ads_banner`.`active`='1' ORDER BY rand() ASC LIMIT 1110
26SELECT `Ads_banner`.`banner_id`, `Ads_banner`.`zone_id`, `Ads_banner`.`layout`, `Ads_banner`.`cat_id`, `Ads_banner`.`sub_id`, `Ads_banner`.`sub2_id`, `Ads_banner`.`name`, `Ads_banner`.`type`, `Ads_banner`.`filename`, `Ads_banner`.`width`, `Ads_banner`.`height`, `Ads_banner`.`url`, `Ads_banner`.`alt`, `Ads_banner`.`weight`, `Ads_banner`.`active`, `Ads_zone`.`zone_id`, `Ads_zone`.`name`, `Ads_zone`.`description`, `Ads_zone`.`type`, `Ads_zone`.`break`, `Ads_zone`.`active` FROM `ads_banner` AS `Ads_banner` LEFT JOIN `ads_zone` AS `Ads_zone` ON (`Ads_banner`.`zone_id` = `Ads_zone`.`zone_id`) WHERE `Ads_banner`.`zone_id`='2' and `Ads_banner`.`layout`='global' and `Ads_banner`.`cat_id`='-1' and `Ads_banner`.`sub_id`='-1' and `Ads_banner`.`sub2_id`='-1' and `Ads_banner`.`active`='1' ORDER BY `Ads_banner`.`weight` ASC 000
27SELECT `Ads_banner`.`banner_id`, `Ads_banner`.`zone_id`, `Ads_banner`.`layout`, `Ads_banner`.`cat_id`, `Ads_banner`.`sub_id`, `Ads_banner`.`sub2_id`, `Ads_banner`.`name`, `Ads_banner`.`type`, `Ads_banner`.`filename`, `Ads_banner`.`width`, `Ads_banner`.`height`, `Ads_banner`.`url`, `Ads_banner`.`alt`, `Ads_banner`.`weight`, `Ads_banner`.`active`, `Ads_zone`.`zone_id`, `Ads_zone`.`name`, `Ads_zone`.`description`, `Ads_zone`.`type`, `Ads_zone`.`break`, `Ads_zone`.`active` FROM `ads_banner` AS `Ads_banner` LEFT JOIN `ads_zone` AS `Ads_zone` ON (`Ads_banner`.`zone_id` = `Ads_zone`.`zone_id`) WHERE `Ads_banner`.`zone_id`='3' and `Ads_banner`.`layout`='global' and `Ads_banner`.`cat_id`='-1' and `Ads_banner`.`sub_id`='-1' and `Ads_banner`.`sub2_id`='-1' and `Ads_banner`.`active`='1' ORDER BY `Ads_banner`.`weight` ASC 000
28SELECT `Ads_banner`.`banner_id`, `Ads_banner`.`zone_id`, `Ads_banner`.`layout`, `Ads_banner`.`cat_id`, `Ads_banner`.`sub_id`, `Ads_banner`.`sub2_id`, `Ads_banner`.`name`, `Ads_banner`.`type`, `Ads_banner`.`filename`, `Ads_banner`.`width`, `Ads_banner`.`height`, `Ads_banner`.`url`, `Ads_banner`.`alt`, `Ads_banner`.`weight`, `Ads_banner`.`active`, `Ads_zone`.`zone_id`, `Ads_zone`.`name`, `Ads_zone`.`description`, `Ads_zone`.`type`, `Ads_zone`.`break`, `Ads_zone`.`active` FROM `ads_banner` AS `Ads_banner` LEFT JOIN `ads_zone` AS `Ads_zone` ON (`Ads_banner`.`zone_id` = `Ads_zone`.`zone_id`) WHERE `Ads_banner`.`zone_id`='4' and `Ads_banner`.`layout`='global' and `Ads_banner`.`cat_id`='-1' and `Ads_banner`.`sub_id`='-1' and `Ads_banner`.`sub2_id`='-1' and `Ads_banner`.`active`='1' ORDER BY `Ads_banner`.`weight` ASC 110
29SELECT `Config`.`conf_id`, `Config`.`key`, `Config`.`value`, `Config`.`description` FROM `config` AS `Config` WHERE 1 = 1 20200
30SELECT `Break_news`.`id`, `Break_news`.`break_news` FROM `break_news` AS `Break_news` WHERE 1 = 1 110
31SELECT `News`.`news_id`, `News`.`cat_id`, `News`.`sub_id`, `News`.`sub2_id`, `News`.`title`, `News`.`description`, `News`.`thum`, `News`.`writer`, `News`.`source`, `News`.`post_date`, `News`.`post_by`, `News`.`read`, `News`.`read_per_week`, `News_text`.`news_id`, `News_text`.`text`, `News_text`.`keyword` FROM `news` AS `News` LEFT JOIN `news_text` AS `News_text` ON (`News_text`.`news_id` = `News`.`news_id`) WHERE `News`.`cat_id` in (17) ORDER BY `News`.`post_date` DESC LIMIT 6660
32SELECT `Poll`.`poll_id`, `Poll`.`question`, `Poll`.`option_1`, `Poll`.`value_1`, `Poll`.`option_2`, `Poll`.`value_2`, `Poll`.`option_3`, `Poll`.`value_3`, `Poll`.`option_4`, `Poll`.`value_4`, `Poll`.`option_5`, `Poll`.`value_5`, `Poll`.`option_6`, `Poll`.`value_6`, `Poll`.`option_7`, `Poll`.`value_7`, `Poll`.`option_8`, `Poll`.`value_8`, `Poll`.`post_date`, `Poll`.`active` FROM `poll` AS `Poll` WHERE `Poll`.`active`='1' ORDER BY `Poll`.`post_date` DESC LIMIT 1110
33SELECT `Section`.`block_id`, `Section`.`title`, `Section`.`image`, `Section`.`text`, `Section`.`last_update` FROM `section` AS `Section` WHERE 1 = 1 220
34SELECT `News`.`news_id`, `News`.`cat_id`, `News`.`sub_id`, `News`.`sub2_id`, `News`.`title`, `News`.`description`, `News`.`thum`, `News`.`writer`, `News`.`source`, `News`.`post_date`, `News`.`post_by`, `News`.`read`, `News`.`read_per_week`, `News_text`.`news_id`, `News_text`.`text`, `News_text`.`keyword` FROM `news` AS `News` LEFT JOIN `news_text` AS `News_text` ON (`News_text`.`news_id` = `News`.`news_id`) WHERE `News`.`cat_id` in (1) ORDER BY `News`.`post_date` DESC LIMIT 6660
35SELECT `News`.`news_id`, `News`.`title` FROM `news` AS `News` LEFT JOIN `news_text` AS `News_text` ON (`News_text`.`news_id` = `News`.`news_id`) WHERE `News`.`cat_id` in (1) ORDER BY `News`.`post_date` DESC LIMIT 1010100
36SELECT `News`.`news_id`, `News`.`title` FROM `news` AS `News` LEFT JOIN `news_text` AS `News_text` ON (`News_text`.`news_id` = `News`.`news_id`) WHERE 1 = 1 ORDER BY `News`.`news_id` desc LIMIT 6660
37SELECT `News`.`news_id`, `News`.`cat_id`, `News`.`sub_id`, `News`.`sub2_id`, `News`.`title`, `News`.`description`, `News`.`thum`, `News`.`writer`, `News`.`source`, `News`.`post_date`, `News`.`post_by`, `News`.`read`, `News`.`read_per_week`, `News_text`.`news_id`, `News_text`.`text`, `News_text`.`keyword` FROM `news` AS `News` LEFT JOIN `news_text` AS `News_text` ON (`News_text`.`news_id` = `News`.`news_id`) WHERE `News`.`news_id` = 223 LIMIT 1000
38SELECT COUNT(id) AS count FROM `sessions` WHERE `id` = '8d9d1ecd691ce6b5aaac9b947018afd7'110
39UPDATE `sessions` SET `data` = 'Config|a:3:{s:9:\"userAgent\";s:32:\"47b5ebf315f6532e99170440faac93cd\";s:4:\"time\";i:1328605773;s:4:\"rand\";i:2083165814;}', `expires` = 1328605773 WHERE `id` = '8d9d1ecd691ce6b5aaac9b947018afd7'10