SHOW FULL COLUMNS FROM `shop_productinfo` [ RunTime:0.005011s ]
SELECT `id`,`title`,`pic`,`contentinfo` FROM `shop_productinfo` WHERE `price` = 'y' AND `status` >= 1 ORDER BY `id` ASC [ RunTime:0.004227s ]
SHOW FULL COLUMNS FROM `shop_scriptinfo` [ RunTime:0.005011s ]
SELECT `address`,`mobile`,`email` FROM `shop_scriptinfo` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001992s ]
SELECT `copyright`,`it` FROM `shop_scriptinfo` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000311s ]
SELECT `lphone`,`qq`,`email` FROM `shop_scriptinfo` WHERE `id` = 4 LIMIT 1 [ RunTime:0.000335s ]
SELECT `contentinfo` FROM `shop_scriptinfo` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000318s ]
SHOW FULL COLUMNS FROM `shop_otherbenefits` [ RunTime:0.002161s ]
SELECT `working`,`benefits`,`activities`,`growth`,`environment`,`otherbenefits` FROM `shop_otherbenefits` WHERE `id` = 5 LIMIT 1 [ RunTime:0.002353s ]
SHOW FULL COLUMNS FROM `shop_newsinfoen` [ RunTime:0.002845s ]
SELECT `id`,`title`,`pic`,`time` FROM `shop_newsinfoen` LIMIT 6 [ RunTime:0.003142s ]
SHOW FULL COLUMNS FROM `shop_newsinfo` [ RunTime:0.002172s ]
SELECT `id`,`pic`,`title`,`time`,`description` FROM `shop_newsinfo` WHERE `flag` = 't' AND `status` = 1 ORDER BY `time` DESC LIMIT 1 [ RunTime:0.007146s ]
SELECT COUNT(*) AS think_count FROM `shop_newsinfo` WHERE `status` = 1 LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`pic`,`title`,`time`,`description` FROM `shop_newsinfo` WHERE `status` = 1 ORDER BY `time` DESC LIMIT 78,6 [ RunTime:0.000635s ]
SELECT `id`,`pic`,`title`,`time`,`description` FROM `shop_newsinfo` WHERE `flag` = 'h' AND `status` = 1 ORDER BY `time` DESC [ RunTime:0.000538s ]
SHOW FULL COLUMNS FROM `shop_fgsinfo` [ RunTime:0.010300s ]
SELECT * FROM `shop_fgsinfo` WHERE `status` = 1 ORDER BY `time` DESC [ RunTime:0.009121s ]
SHOW FULL COLUMNS FROM `shop_usatype` [ RunTime:0.001791s ]
SELECT `smid`,`type` FROM `shop_usatype` [ RunTime:0.005881s ]
SHOW FULL COLUMNS FROM `shop_usainfo` [ RunTime:0.002309s ]
SELECT * FROM `shop_usainfo` `a` INNER JOIN `shop_usatype` `w` ON `a`.`p_smid`=`w`.`smid` WHERE `status` = 1 AND `p_smid` = 2 ORDER BY `a`.`time` DESC [ RunTime:0.007729s ]