SHOW FULL COLUMNS FROM `db_article` [ RunTime:0.000822s ]
SELECT * FROM `db_article` WHERE `catid` = 2 ORDER BY `list` DESC,`id` DESC LIMIT 5 [ RunTime:0.000293s ]
SELECT * FROM `db_article` WHERE `catid` = 3 ORDER BY `list` DESC,`id` DESC LIMIT 5 [ RunTime:0.000587s ]
SELECT * FROM `db_article` WHERE `catid` = 4 ORDER BY `list` DESC,`id` DESC LIMIT 5 [ RunTime:0.000455s ]
SELECT * FROM `db_article` WHERE `catid` = 5 ORDER BY `list` DESC,`id` DESC LIMIT 5 [ RunTime:0.000437s ]
SELECT * FROM `db_article` WHERE `catid` = 6 ORDER BY `list` DESC,`id` DESC LIMIT 5 [ RunTime:0.000448s ]
SHOW FULL COLUMNS FROM `db_ad` [ RunTime:0.000809s ]
SELECT * FROM `db_ad` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000279s ]
SHOW FULL COLUMNS FROM `db_navigation` [ RunTime:0.000626s ]
SELECT * FROM `db_navigation` WHERE `is_lock` = 0 ORDER BY `list` DESC,`id` ASC [ RunTime:0.000282s ]
SHOW FULL COLUMNS FROM `db_friend_link` [ RunTime:0.000546s ]
SELECT * FROM `db_friend_link` WHERE `is_lock` = 0 ORDER BY `list` DESC,`id` ASC [ RunTime:0.000245s ]
SHOW FULL COLUMNS FROM `db_system` [ RunTime:0.000621s ]
SELECT * FROM `db_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000280s ]
SHOW FULL COLUMNS FROM `db_goods` [ RunTime:0.000838s ]
SELECT * FROM `db_goods` WHERE `id` = 100 LIMIT 1 [ RunTime:0.000529s ]
SHOW FULL COLUMNS FROM `db_goods_brand` [ RunTime:0.000687s ]
SELECT * FROM `db_goods_brand` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000251s ]
SHOW FULL COLUMNS FROM `db_goods_attr` [ RunTime:0.000555s ]
SELECT * FROM `db_goods_attr` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000232s ]
SHOW FULL COLUMNS FROM `db_goods_spec` [ RunTime:0.000521s ]
SELECT * FROM `db_goods_spec` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000231s ]
SHOW FULL COLUMNS FROM `db_goods_spec_price` [ RunTime:0.000534s ]
SELECT * FROM `db_goods_spec_price` WHERE `gid` = 100 [ RunTime:0.000325s ]
SHOW FULL COLUMNS FROM `db_goods_spec_image` [ RunTime:0.000513s ]
SELECT * FROM `db_goods_spec_image` WHERE `goods_id` = 100 [ RunTime:0.000218s ]
SHOW FULL COLUMNS FROM `db_goods_vote` [ RunTime:0.000582s ]
SELECT COUNT(*) AS think_count FROM `db_goods_vote` WHERE `goodsid` = 100 LIMIT 1 [ RunTime:0.000277s ]
SELECT COUNT(*) AS think_count FROM `db_goods_vote` WHERE `goodsid` = 100 AND `stars` >= '3.5' LIMIT 1 [ RunTime:0.000287s ]
SELECT COUNT(*) AS think_count FROM `db_goods_vote` WHERE `goodsid` = 100 AND `stars` > '2' AND `stars` < '3.5' LIMIT 1 [ RunTime:0.000283s ]
SELECT COUNT(*) AS think_count FROM `db_goods_vote` WHERE `goodsid` = 100 AND `stars` <= '2' LIMIT 1 [ RunTime:0.000271s ]
SELECT COUNT(*) AS think_count FROM `db_goods_vote` WHERE `goodsid` = 100 AND `photos` IS NOT NULL OR `addtophotos` IS NOT NULL LIMIT 1 [ RunTime:0.000275s ]
SELECT * FROM `db_goods` WHERE `is_show` = 1 AND `is_comm` = 1 ORDER BY `list` DESC,`id` DESC LIMIT 5 [ RunTime:0.000281s ]
