| 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.000 | 69 |
| select count(*) count from `sessions` WHERE last_activity >1337727347 | 0.064 | 1 |
| SELECT *
FROM `sessions`
WHERE `session_id` = 'ba452614749e2639538374689720334b'
LIMIT 0, 1 | 0.000 | 0 |
| select * from search_keys order by hits desc limit 0,8 | 0.059 | 4 |
| SELECT `pages`.*
FROM `pages`
WHERE `title` LIKE '%关于我们%'
ORDER BY `id` DESC
LIMIT 0, 1 | 0.072 | 1 |
| SELECT `pages`.*
FROM `pages`
WHERE `title` LIKE '%联系我们%'
ORDER BY `id` DESC
LIMIT 0, 1 | 0.001 | 1 |
| SELECT `pages`.*
FROM `pages`
WHERE `title` LIKE '%掌商联盟%'
ORDER BY `id` DESC
LIMIT 0, 1 | 0.000 | 0 |
| SELECT `web_navigations`.*
FROM `web_navigations`
WHERE `navigation_cat_id` = 0
ORDER BY `id` ASC | 0.004 | 6 |
| INSERT INTO `visitors` (`ip`, `fromurl`, `tourl`, `searchtype`, `keywords`, `created`) VALUES ('38.107.179.228', '', 'http://shoes.zhangshang.mobi/web2/welcome/index', 0, '', 1337727647) | 0.001 | 1 |
| select tourl,created from visitors where tourl='' and ip='38.107.179.228' and created>1337727047 and 1337727647-created>5 order by id desc limit 0,1 | 0.001 | 0 |
| INSERT INTO `out_pages` (`ip`, `page`, `created`) VALUES ('38.107.179.228', 'http://shoes.zhangshang.mobi/web2/welcome/index', 1337727647) | 0.001 | 1 |
| SELECT `id`, `name`
FROM `mall_cats`
WHERE `parent_id` = 0
AND `published` = 1
ORDER BY `sort_order` ASC | 0.584 | 4 |
| SELECT `id`, `name`
FROM `mall_cats`
WHERE `parent_id` = '3'
AND `published` = 1
ORDER BY `sort_order` ASC
LIMIT 0, 4 | 0.289 | 0 |
| SELECT `id`, `name`
FROM `mall_cats`
WHERE `parent_id` = '4'
AND `published` = 1
ORDER BY `sort_order` ASC
LIMIT 0, 4 | 0.033 | 0 |
| SELECT `id`, `name`
FROM `mall_cats`
WHERE `parent_id` = '5'
AND `published` = 1
ORDER BY `sort_order` ASC
LIMIT 0, 4 | 0.001 | 0 |
| SELECT `id`, `name`
FROM `mall_cats`
WHERE `parent_id` = '6'
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.132 | 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.051 | 1 |
| SELECT id, name , user_id FROM companies WHERE published=1 ORDER BY zhangshang_site_id desc,created desc LIMIT 0, 18 | 0.028 | 18 |
| SELECT id, name FROM news_cats WHERE published=1 and parent_id=0 ORDER BY sort_order ASC LIMIT 0, 4 | 0.023 | 4 |
| SELECT id, title FROM news WHERE published=1 AND recent=1 AND mapping LIKE '56,%' OR mapping LIKE '%,56,%' ORDER BY top desc,created desc LIMIT 0, 5 | 0.052 | 5 |
| SELECT id, title FROM news WHERE published=1 AND recent=1 AND mapping LIKE '57,%' OR mapping LIKE '%,57,%' ORDER BY top desc,created desc LIMIT 0, 5 | 0.012 | 5 |
| SELECT id, title FROM news WHERE published=1 AND recent=1 AND mapping LIKE '58,%' OR mapping LIKE '%,58,%' 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 '59,%' OR mapping LIKE '%,59,%' ORDER BY top desc,created desc LIMIT 0, 5 | 0.015 | 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.001 | 12 |
| SELECT id, title FROM news WHERE published=1 AND recent=1 ORDER BY hits desc LIMIT 0, 18 | 0.003 | 18 |
| SELECT id, title, trade_type FROM trades WHERE recommend=1 AND audit=1 ORDER BY created desc LIMIT 0, 15 | 0.046 | 0 |
| SELECT id, name FROM provinces ORDER BY sort_order ASC LIMIT 0, 10 | 0.016 | 10 |
| SELECT `tag`, `value`
FROM `seos`
WHERE `tag` = 'valide_string'
ORDER BY `tag` ASC | 0.002 | 1 |
| select * from search_keys order by hits desc limit 0,6 | 0.000 | 4 |
| 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.000 | 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.002 | 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.002 | 0 |
| SELECT `ad_cats`.*
FROM `ad_cats`
WHERE `tag` = 'index_roll'
AND `published` = 1
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `ad_cats`.*
FROM `ad_cats`
WHERE `tag` = 'index_roll'
AND `published` = 1
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `ads`.*
FROM `ads`
WHERE `ad_cat_id` = 8
AND `published` = 1
ORDER BY `id` ASC | 0.000 | 0 |
| SELECT `users`.*
FROM `users`
WHERE `reg_from` = 1
AND `payed` = 1
AND `id` = 14
LIMIT 0, 1 | 0.001 | 0 |
| SELECT `users`.*
FROM `users`
WHERE `reg_from` = 1
AND `payed` = 1
AND `id` = 13
LIMIT 0, 1 | 0.000 | 0 |
| SELECT `users`.*
FROM `users`
WHERE `reg_from` = 1
AND `payed` = 1
AND `id` = 9
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.000 | 0 |
| SELECT `ad_cats`.*
FROM `ad_cats`
WHERE `tag` = 'index_middle2'
AND `published` = 1
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `ad_cats`.*
FROM `ad_cats`
WHERE `tag` = 'index_middle2'
AND `published` = 1
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `ads`.*
FROM `ads`
WHERE `ad_cat_id` = 12
AND `published` = 1
ORDER BY `id` ASC | 0.000 | 0 |
| 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.000 | 1 |
| SELECT `ads`.*
FROM `ads`
WHERE `ad_cat_id` = 13
AND `published` = 1
ORDER BY `id` ASC | 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.000 | 1 |
| SELECT `ads`.*
FROM `ads`
WHERE `ad_cat_id` = 15
AND `published` = 1
ORDER BY `id` ASC | 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.000 | 0 |
| 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 | 0 |
| Total: 62 | 1.504 | 220 |
养生鞋业有限公司
