| Queries | Time | Rows |
| select value from configs where tag='web_template_id' | 0.000 | 1 |
| SELECT `tag`, `value`
FROM `configs`
ORDER BY `tag` ASC | 0.001 | 69 |
| select count(*) count from `sessions` WHERE last_activity >1337508089 | 0.088 | 1 |
| SELECT *
FROM `sessions`
WHERE `session_id` = '677069c7ef3bfd4dd1df56aa56b7a6ba'
LIMIT 0, 1 | 0.067 | 0 |
| select * from search_keys order by hits desc limit 0,8 | 0.000 | 8 |
| SELECT `pages`.*
FROM `pages`
WHERE `title` LIKE '%关于我们%'
ORDER BY `id` DESC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `pages`.*
FROM `pages`
WHERE `title` LIKE '%联系我们%'
ORDER BY `id` DESC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `pages`.*
FROM `pages`
WHERE `title` LIKE '%掌商联盟%'
ORDER BY `id` DESC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `web_navigations`.*
FROM `web_navigations`
WHERE `navigation_cat_id` = 0
ORDER BY `id` ASC | 0.001 | 6 |
| INSERT INTO `visitors` (`ip`, `fromurl`, `tourl`, `searchtype`, `keywords`, `created`) VALUES ('38.107.179.226', '', 'http://907.zhangshang.mobi/web2/welcome/index', 0, '', 1337508389) | 0.002 | 1 |
| select tourl,created from visitors where tourl='' and ip='38.107.179.226' and created>1337507789 and 1337508389-created>5 order by id desc limit 0,1 | 0.000 | 0 |
| INSERT INTO `out_pages` (`ip`, `page`, `created`) VALUES ('38.107.179.226', 'http://907.zhangshang.mobi/web2/welcome/index', 1337508389) | 0.000 | 1 |
| SELECT `id`, `name`
FROM `mall_cats`
WHERE `parent_id` = 0
AND `published` = 1
ORDER BY `sort_order` ASC | 0.787 | 5 |
| SELECT `id`, `name`
FROM `mall_cats`
WHERE `parent_id` = '1'
AND `published` = 1
ORDER BY `sort_order` ASC
LIMIT 0, 4 | 0.073 | 0 |
| SELECT `id`, `name`
FROM `mall_cats`
WHERE `parent_id` = '3'
AND `published` = 1
ORDER BY `sort_order` ASC
LIMIT 0, 4 | 0.000 | 0 |
| SELECT `id`, `name`
FROM `mall_cats`
WHERE `parent_id` = '4'
AND `published` = 1
ORDER BY `sort_order` ASC
LIMIT 0, 4 | 0.001 | 0 |
| SELECT `id`, `name`
FROM `mall_cats`
WHERE `parent_id` = '7'
AND `published` = 1
ORDER BY `sort_order` ASC
LIMIT 0, 4 | 0.000 | 0 |
| SELECT `id`, `name`
FROM `mall_cats`
WHERE `parent_id` = '2'
AND `published` = 1
ORDER BY `sort_order` ASC
LIMIT 0, 4 | 0.000 | 0 |
| SELECT mp.id, mp.name, mp.prices, mpa.file
FROM mall_products mp LEFT JOIN mall_product_attaches mpa ON mp.id = mpa.mall_product_id
WHERE mp.status=1
GROUP BY mp.id ORDER BY mp.created desc
LIMIT 0, 5 | 0.184 | 5 |
| SELECT id, name, img1,user_id FROM companies WHERE published=1 and recommend=1 and img1 IS NOT NULL AND img1 !='' ORDER BY zhangshang_site_id desc,created desc LIMIT 0, 8 | 0.191 | 8 |
| SELECT id, name , user_id FROM companies WHERE published=1 ORDER BY zhangshang_site_id desc,created desc LIMIT 0, 18 | 0.174 | 18 |
| SELECT id, name FROM news_cats WHERE published=1 and parent_id=0 ORDER BY sort_order ASC LIMIT 0, 4 | 0.055 | 4 |
| SELECT id, title FROM news WHERE published=1 AND recent=1 AND mapping LIKE '90,%' OR mapping LIKE '%,90,%' ORDER BY top desc,created desc LIMIT 0, 5 | 0.098 | 5 |
| SELECT id, title FROM news WHERE published=1 AND recent=1 AND mapping LIKE '97,%' OR mapping LIKE '%,97,%' ORDER BY top desc,created desc LIMIT 0, 5 | 0.065 | 5 |
| SELECT id, title FROM news WHERE published=1 AND recent=1 AND mapping LIKE '98,%' OR mapping LIKE '%,98,%' ORDER BY top desc,created desc LIMIT 0, 5 | 0.001 | 5 |
| SELECT id, title FROM news WHERE published=1 AND recent=1 AND mapping LIKE '99,%' OR mapping LIKE '%,99,%' ORDER BY top desc,created desc LIMIT 0, 5 | 0.001 | 5 |
| SELECT id, name ,user_id FROM companies WHERE published=1 and recommend=1 ORDER BY created DESC LIMIT 0, 12 | 0.001 | 12 |
| SELECT id, name ,user_id FROM companies WHERE published=1 AND attestation=1 ORDER BY created DESC LIMIT 0, 12 | 0.002 | 12 |
| SELECT id, title FROM news WHERE published=1 AND recent=1 ORDER BY hits desc LIMIT 0, 18 | 0.002 | 18 |
| SELECT id, title, trade_type FROM trades WHERE recommend=1 AND audit=1 ORDER BY created desc LIMIT 0, 15 | 0.554 | 15 |
| SELECT id, name FROM provinces ORDER BY sort_order ASC LIMIT 0, 10 | 0.548 | 10 |
| SELECT `tag`, `value`
FROM `seos`
WHERE `tag` = 'valide_string'
ORDER BY `tag` ASC | 0.000 | 1 |
| select * from search_keys order by hits desc limit 0,6 | 0.000 | 6 |
| select value from configs where tag='web_template_id' | 0.000 | 1 |
| SELECT `web_navigations`.*
FROM `web_navigations`
WHERE `name` = '首页'
AND `published` = 1
AND `navigation_cat_id` = 0
LIMIT 0, 1 | 0.001 | 1 |
| SELECT `web_navigations`.*
FROM `web_navigations`
WHERE `navigation_cat_id` = 1
AND `published` = 1
AND `web_template_id` = 2
ORDER BY `id` ASC | 0.000 | 8 |
| SELECT `ad_cats`.*
FROM `ad_cats`
WHERE `tag` = 'index_top1'
AND `published` = 1
LIMIT 0, 1 | 0.001 | 1 |
| SELECT `ad_cats`.*
FROM `ad_cats`
WHERE `tag` = 'index_top1'
AND `published` = 1
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `ads`.*
FROM `ads`
WHERE `ad_cat_id` = 9
AND `published` = 1
ORDER BY `id` ASC | 0.001 | 17 |
| SELECT `ad_cats`.*
FROM `ad_cats`
WHERE `tag` = 'index_roll'
AND `published` = 1
LIMIT 0, 1 | 0.001 | 1 |
| SELECT `ad_cats`.*
FROM `ad_cats`
WHERE `tag` = 'index_roll'
AND `published` = 1
LIMIT 0, 1 | 0.001 | 1 |
| SELECT `ads`.*
FROM `ads`
WHERE `ad_cat_id` = 8
AND `published` = 1
ORDER BY `id` ASC | 0.000 | 10 |
| SELECT `users`.*
FROM `users`
WHERE `reg_from` = 1
AND `payed` = 1
AND `id` = 108
LIMIT 0, 1 | 0.127 | 0 |
| SELECT `users`.*
FROM `users`
WHERE `reg_from` = 1
AND `payed` = 1
AND `id` = 127
LIMIT 0, 1 | 0.002 | 0 |
| SELECT `users`.*
FROM `users`
WHERE `reg_from` = 1
AND `payed` = 1
AND `id` = 126
LIMIT 0, 1 | 0.079 | 0 |
| SELECT `users`.*
FROM `users`
WHERE `reg_from` = 1
AND `payed` = 1
AND `id` = 125
LIMIT 0, 1 | 0.001 | 0 |
| SELECT `users`.*
FROM `users`
WHERE `reg_from` = 1
AND `payed` = 1
AND `id` = 123
LIMIT 0, 1 | 0.056 | 0 |
| SELECT `users`.*
FROM `users`
WHERE `reg_from` = 1
AND `payed` = 1
AND `id` = 122
LIMIT 0, 1 | 0.019 | 0 |
| SELECT `users`.*
FROM `users`
WHERE `reg_from` = 1
AND `payed` = 1
AND `id` = 120
LIMIT 0, 1 | 0.001 | 0 |
| SELECT `users`.*
FROM `users`
WHERE `reg_from` = 1
AND `payed` = 1
AND `id` = 119
LIMIT 0, 1 | 0.001 | 0 |
| SELECT `users`.*
FROM `users`
WHERE `reg_from` = 1
AND `payed` = 1
AND `id` = 161
LIMIT 0, 1 | 0.000 | 0 |
| SELECT `users`.*
FROM `users`
WHERE `reg_from` = 1
AND `payed` = 1
AND `id` = 157
LIMIT 0, 1 | 0.001 | 0 |
| SELECT `users`.*
FROM `users`
WHERE `reg_from` = 1
AND `payed` = 1
AND `id` = 155
LIMIT 0, 1 | 0.001 | 0 |
| SELECT `users`.*
FROM `users`
WHERE `reg_from` = 1
AND `payed` = 1
AND `id` = 153
LIMIT 0, 1 | 0.001 | 0 |
| SELECT `users`.*
FROM `users`
WHERE `reg_from` = 1
AND `payed` = 1
AND `id` = 152
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `users`.*
FROM `users`
WHERE `reg_from` = 1
AND `payed` = 1
AND `id` = 151
LIMIT 0, 1 | 0.000 | 0 |
| SELECT `users`.*
FROM `users`
WHERE `reg_from` = 1
AND `payed` = 1
AND `id` = 150
LIMIT 0, 1 | 0.001 | 0 |
| SELECT `users`.*
FROM `users`
WHERE `reg_from` = 1
AND `payed` = 1
AND `id` = 149
LIMIT 0, 1 | 0.000 | 0 |
| SELECT `users`.*
FROM `users`
WHERE `reg_from` = 1
AND `payed` = 1
AND `id` = 148
LIMIT 0, 1 | 0.000 | 0 |
| SELECT `users`.*
FROM `users`
WHERE `reg_from` = 1
AND `payed` = 1
AND `id` = 147
LIMIT 0, 1 | 0.000 | 0 |
| SELECT `users`.*
FROM `users`
WHERE `reg_from` = 1
AND `payed` = 1
AND `id` = 146
LIMIT 0, 1 | 0.039 | 0 |
| SELECT `users`.*
FROM `users`
WHERE `reg_from` = 1
AND `payed` = 1
AND `id` = 145
LIMIT 0, 1 | 0.003 | 0 |
| SELECT `users`.*
FROM `users`
WHERE `reg_from` = 1
AND `payed` = 1
AND `id` = 144
LIMIT 0, 1 | 0.001 | 0 |
| SELECT `users`.*
FROM `users`
WHERE `reg_from` = 1
AND `payed` = 1
AND `id` = 143
LIMIT 0, 1 | 0.001 | 0 |
| SELECT `users`.*
FROM `users`
WHERE `reg_from` = 1
AND `payed` = 1
AND `id` = 142
LIMIT 0, 1 | 0.000 | 0 |
| SELECT `users`.*
FROM `users`
WHERE `reg_from` = 1
AND `payed` = 1
AND `id` = 141
LIMIT 0, 1 | 0.000 | 0 |
| SELECT `users`.*
FROM `users`
WHERE `reg_from` = 1
AND `payed` = 1
AND `id` = 140
LIMIT 0, 1 | 0.000 | 0 |
| SELECT `ad_cats`.*
FROM `ad_cats`
WHERE `tag` = 'index_middle1'
AND `published` = 1
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `ad_cats`.*
FROM `ad_cats`
WHERE `tag` = 'index_middle1'
AND `published` = 1
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `ads`.*
FROM `ads`
WHERE `ad_cat_id` = 11
AND `published` = 1
ORDER BY `id` ASC | 0.033 | 2 |
| SELECT `ad_cats`.*
FROM `ad_cats`
WHERE `tag` = 'index_middle2'
AND `published` = 1
LIMIT 0, 1 | 0.017 | 1 |
| SELECT `ad_cats`.*
FROM `ad_cats`
WHERE `tag` = 'index_middle2'
AND `published` = 1
LIMIT 0, 1 | 0.002 | 1 |
| SELECT `ads`.*
FROM `ads`
WHERE `ad_cat_id` = 12
AND `published` = 1
ORDER BY `id` ASC | 0.001 | 12 |
| SELECT `ad_cats`.*
FROM `ad_cats`
WHERE `tag` = 'index_bottom1'
AND `published` = 1
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `ad_cats`.*
FROM `ad_cats`
WHERE `tag` = 'index_bottom1'
AND `published` = 1
LIMIT 0, 1 | 0.002 | 1 |
| SELECT `ads`.*
FROM `ads`
WHERE `ad_cat_id` = 13
AND `published` = 1
ORDER BY `id` ASC | 0.000 | 2 |
| SELECT `users`.*
FROM `users`
WHERE `reg_from` = 1
AND `payed` = 1
AND `id` = 157
LIMIT 0, 1 | 0.000 | 0 |
| SELECT `users`.*
FROM `users`
WHERE `reg_from` = 1
AND `payed` = 1
AND `id` = 153
LIMIT 0, 1 | 0.000 | 0 |
| SELECT `users`.*
FROM `users`
WHERE `reg_from` = 1
AND `payed` = 1
AND `id` = 152
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `users`.*
FROM `users`
WHERE `reg_from` = 1
AND `payed` = 1
AND `id` = 151
LIMIT 0, 1 | 0.000 | 0 |
| SELECT `users`.*
FROM `users`
WHERE `reg_from` = 1
AND `payed` = 1
AND `id` = 150
LIMIT 0, 1 | 0.000 | 0 |
| SELECT `users`.*
FROM `users`
WHERE `reg_from` = 1
AND `payed` = 1
AND `id` = 149
LIMIT 0, 1 | 0.001 | 0 |
| SELECT `users`.*
FROM `users`
WHERE `reg_from` = 1
AND `payed` = 1
AND `id` = 148
LIMIT 0, 1 | 0.000 | 0 |
| SELECT `users`.*
FROM `users`
WHERE `reg_from` = 1
AND `payed` = 1
AND `id` = 147
LIMIT 0, 1 | 0.000 | 0 |
| SELECT `users`.*
FROM `users`
WHERE `reg_from` = 1
AND `payed` = 1
AND `id` = 146
LIMIT 0, 1 | 0.000 | 0 |
| SELECT `users`.*
FROM `users`
WHERE `reg_from` = 1
AND `payed` = 1
AND `id` = 145
LIMIT 0, 1 | 0.004 | 0 |
| SELECT `users`.*
FROM `users`
WHERE `reg_from` = 1
AND `payed` = 1
AND `id` = 144
LIMIT 0, 1 | 0.000 | 0 |
| SELECT `ad_cats`.*
FROM `ad_cats`
WHERE `tag` = 'index_right1'
AND `published` = 1
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `ad_cats`.*
FROM `ad_cats`
WHERE `tag` = 'index_right1'
AND `published` = 1
LIMIT 0, 1 | 0.001 | 1 |
| SELECT `ads`.*
FROM `ads`
WHERE `ad_cat_id` = 15
AND `published` = 1
ORDER BY `id` ASC | 0.000 | 2 |
| SELECT `users`.*
FROM `users`
WHERE `reg_from` = 1
AND `payed` = 1
AND `id` = 153
LIMIT 0, 1 | 0.000 | 0 |
| SELECT `users`.*
FROM `users`
WHERE `reg_from` = 1
AND `payed` = 1
AND `id` = 152
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `users`.*
FROM `users`
WHERE `reg_from` = 1
AND `payed` = 1
AND `id` = 151
LIMIT 0, 1 | 0.003 | 0 |
| SELECT `users`.*
FROM `users`
WHERE `reg_from` = 1
AND `payed` = 1
AND `id` = 150
LIMIT 0, 1 | 0.001 | 0 |
| SELECT `users`.*
FROM `users`
WHERE `reg_from` = 1
AND `payed` = 1
AND `id` = 149
LIMIT 0, 1 | 0.001 | 0 |
| SELECT `users`.*
FROM `users`
WHERE `reg_from` = 1
AND `payed` = 1
AND `id` = 148
LIMIT 0, 1 | 0.001 | 0 |
| SELECT `users`.*
FROM `users`
WHERE `reg_from` = 1
AND `payed` = 1
AND `id` = 147
LIMIT 0, 1 | 0.000 | 0 |
| SELECT `users`.*
FROM `users`
WHERE `reg_from` = 1
AND `payed` = 1
AND `id` = 146
LIMIT 0, 1 | 0.000 | 0 |
| SELECT `users`.*
FROM `users`
WHERE `reg_from` = 1
AND `payed` = 1
AND `id` = 145
LIMIT 0, 1 | 0.000 | 0 |
| SELECT `users`.*
FROM `users`
WHERE `reg_from` = 1
AND `payed` = 1
AND `id` = 144
LIMIT 0, 1 | 0.000 | 0 |
| SELECT `users`.*
FROM `users`
WHERE `reg_from` = 1
AND `payed` = 1
AND `id` = 143
LIMIT 0, 1 | 0.000 | 0 |
| SELECT `ad_cats`.*
FROM `ad_cats`
WHERE `tag` = 'index_right2'
AND `published` = 1
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `ad_cats`.*
FROM `ad_cats`
WHERE `tag` = 'index_right2'
AND `published` = 1
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `ads`.*
FROM `ads`
WHERE `ad_cat_id` = 16
AND `published` = 1
ORDER BY `id` ASC | 0.009 | 2 |
| SELECT `ad_cats`.*
FROM `ad_cats`
WHERE `tag` = 'index_bottom2'
AND `published` = 1
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `ad_cats`.*
FROM `ad_cats`
WHERE `tag` = 'index_bottom2'
AND `published` = 1
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `ads`.*
FROM `ads`
WHERE `ad_cat_id` = 14
AND `published` = 1
ORDER BY `id` ASC | 0.000 | 17 |
| Total: 107 | 3.321 | 317 |