| Queries | Time | Rows |
| SELECT `tag`, `value`
FROM `configs`
ORDER BY `tag` ASC | 0.000 | 70 |
| select count(*) count from `sessions` WHERE last_activity >1329954776 | 0.005 | 1 |
| SELECT *
FROM `sessions`
WHERE `session_id` = '50ab50f73818a0cdeeb70d2a9c3b35a8'
LIMIT 0, 1 | 0.566 | 0 |
| INSERT INTO `visitors` (`ip`, `fromurl`, `tourl`, `searchtype`, `keywords`, `created`) VALUES ('38.107.179.230', '', 'http://lvyou.hy3g.zhangshang.mobi/', 0, '', 1329955077) | 0.000 | 1 |
| select tourl,created from visitors where tourl='' and ip='38.107.179.230' and created>1329954477 and 1329955077-created>5 order by id desc limit 0,1 | 0.001 | 0 |
| INSERT INTO `out_pages` (`ip`, `page`, `created`) VALUES ('38.107.179.230', 'http://lvyou.hy3g.zhangshang.mobi/', 1329955077) | 0.001 | 1 |
| update configs set value=value+1 where tag = 'counter_value' | 0.000 | 1 |
| SELECT `layouts`.*
FROM `layouts`
WHERE `id` = 71
LIMIT 0, 1 | 0.001 | 1 |
| SELECT `layouts`.*
FROM `layouts`
WHERE `id` = 72
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `layouts`.*
FROM `layouts`
WHERE `id` = 73
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `layouts`.*
FROM `layouts`
WHERE `id` = 74
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `layouts`.*
FROM `layouts`
WHERE `id` = 75
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `layouts`.*
FROM `layouts`
WHERE `id` = 76
LIMIT 0, 1 | 0.001 | 1 |
| SELECT `layouts`.*
FROM `layouts`
WHERE `id` = 77
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `layouts`.*
FROM `layouts`
WHERE `id` = 78
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `layouts`.*
FROM `layouts`
WHERE `id` = 79
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `layouts`.*
FROM `layouts`
WHERE `id` = 80
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `layouts`.*
FROM `layouts`
WHERE `id` = 81
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `layouts`.*
FROM `layouts`
WHERE `id` = 82
LIMIT 0, 1 | 0.003 | 1 |
| SELECT `news_cats`.*
FROM `news_cats`
WHERE `published` = 1
AND `parent_id` = 0
ORDER BY `sort_order` ASC
LIMIT 0, 3 | 0.000 | 3 |
| select news.id,news.title,news.img1 as img from news where news.img1 IS NOT NULL and news.published=1 and news.recent=1 order by news.top desc,news.id desc limit 0,0 | 0.000 | 0 |
| select news.id,news.title from news where news.published=1 and news.recent=1 order by news.top desc,news.id desc limit 0,5 | 0.005 | 5 |
| SELECT `mall_cats`.*
FROM `mall_cats`
WHERE `published` = 1
AND `parent_id` = 0
ORDER BY `sort_order` ASC
LIMIT 0, 3 | 0.607 | 3 |
| select mall_products.id,mall_products.name,mall_product_attaches.file as img from mall_products left join mall_product_attaches on mall_products.id=mall_product_attaches.mall_product_id left join `auction_standards` as a ON (mall_products.id=a.info_id and a.module_name='product' and a.`date`=(select max(`date`) from `auction_standards`)) where mall_products.status=1 and mall_products.recent=1 order by a.value desc,mall_products.id desc limit 0,0 | 0.191 | 0 |
| select mall_products.id,mall_products.name from mall_products where mall_products.status=1 order by mall_products.id desc limit 0,5 | 0.001 | 5 |
| SELECT `id`, `name`
FROM `vocations`
WHERE `parent_id` = 0
AND `published` = 1
ORDER BY `sort_order` ASC | 0.060 | 8 |
| select c.* from companies as c left join `auction_standards` as a on (c.user_id=a.user_id and a.module_name='company' and a.`date`=(select max(`date`) from `auction_standards`)) where published=1 and recommend=1 and mapping_vocation like '%' order by a.value desc,c.id desc limit 0,5 | 0.002 | 5 |
| SELECT `trade_cats`.*
FROM `trade_cats`
WHERE `published` = 1
AND `parent_id` = '15'
ORDER BY `sort_order` ASC
LIMIT 0, 3 | 0.006 | 3 |
| SELECT `trade_cats`.*
FROM `trade_cats`
WHERE `published` = 1
AND `parent_id` = 15
ORDER BY `sort_order` ASC | 0.000 | 5 |
| select t.* from trades t left join `auction_standards` a on (t.id=a.info_id and a.module_name='trade' and a.`date`=(select max(`date`) from `auction_standards`)) where audit=1 and deadline >= '2012-02-23' and trade_cat_id IN(15,8,10,12,13,14) order by a.value desc,t.id desc limit 5 | 0.007 | 0 |
| SELECT `trade_cats`.*
FROM `trade_cats`
WHERE `published` = 1
AND `parent_id` = '16'
ORDER BY `sort_order` ASC
LIMIT 0, 3 | 0.001 | 3 |
| SELECT `trade_cats`.*
FROM `trade_cats`
WHERE `published` = 1
AND `parent_id` = 16
ORDER BY `sort_order` ASC | 0.001 | 5 |
| select t.* from trades t left join `auction_standards` a on (t.id=a.info_id and a.module_name='trade' and a.`date`=(select max(`date`) from `auction_standards`)) where audit=1 and deadline >= '2012-02-23' and trade_cat_id IN(16,17,18,19,20,21) order by a.value desc,t.id desc limit 5 | 0.001 | 0 |
| SELECT `forum_cats`.*
FROM `forum_cats`
WHERE `published` = 1
ORDER BY `id` ASC
LIMIT 0, 3 | 0.003 | 3 |
| SELECT `forums`.*
FROM `forums`
WHERE `published` = 1
ORDER BY `id` DESC
LIMIT 0, 5 | 0.013 | 5 |
| SELECT `tag`, `value`
FROM `seos`
WHERE `tag` = 'valide_string'
ORDER BY `tag` ASC | 0.001 | 0 |
| INSERT INTO `sessions` (`session_id`, `last_activity`, `data`) VALUES ('50ab50f73818a0cdeeb70d2a9c3b35a8', 1329955078, 'c2Vzc2lvbl9pZHxzOjMyOiI1MGFiNTBmNzM4MThhMGNkZWViNzBkMmE5YzNiMzVhOCI7dG90YWxfaGl0c3xpOjE7X2tmX2ZsYXNoX3xhOjA6e311c2VyX2FnZW50fHM6NDg6IkNDQm90LzEuMCAoK2h0dHA6Ly93d3cuY29tbW9uY3Jhd2wub3JnL2JvdC5odG1sKSI7aXBfYWRkcmVzc3xzOjE0OiIzOC4xMDcuMTc5LjIzMCI7bGFzdF9hY3Rpdml0eXxpOjEzMjk5NTUwNzc7') | 0.000 | 1 |
| Total: 37 | 1.479 | 140 |
