SHOW FULL COLUMNS FROM `shop_productinfo` [ RunTime:0.008757s ]
SELECT `id`,`title`,`pic`,`contentinfo` FROM `shop_productinfo` WHERE `price` = 'y' AND `status` >= 1 ORDER BY `id` ASC [ RunTime:0.006401s ]
SHOW FULL COLUMNS FROM `shop_scriptinfo` [ RunTime:0.007230s ]
SELECT `address`,`mobile`,`email` FROM `shop_scriptinfo` WHERE `id` = 1 LIMIT 1 [ RunTime:0.004654s ]
SELECT `copyright`,`it` FROM `shop_scriptinfo` WHERE `id` = 2 LIMIT 1 [ RunTime:0.002882s ]
SELECT `lphone`,`qq`,`email` FROM `shop_scriptinfo` WHERE `id` = 4 LIMIT 1 [ RunTime:0.001747s ]
SELECT `contentinfo` FROM `shop_scriptinfo` WHERE `id` = 3 LIMIT 1 [ RunTime:0.001502s ]
SHOW FULL COLUMNS FROM `shop_otherbenefits` [ RunTime:0.002758s ]
SELECT `working`,`benefits`,`activities`,`growth`,`environment`,`otherbenefits` FROM `shop_otherbenefits` WHERE `id` = 5 LIMIT 1 [ RunTime:0.003410s ]
SHOW FULL COLUMNS FROM `shop_newsinfoen` [ RunTime:0.003433s ]
SELECT `id`,`title`,`pic`,`time` FROM `shop_newsinfoen` LIMIT 6 [ RunTime:0.005477s ]
SHOW FULL COLUMNS FROM `shop_newsinfo` [ RunTime:0.002591s ]
SELECT `id`,`pic`,`title`,`time`,`description` FROM `shop_newsinfo` WHERE `flag` = 't' AND `status` = 1 ORDER BY `time` DESC LIMIT 1 [ RunTime:0.004516s ]
SELECT COUNT(*) AS think_count FROM `shop_newsinfo` WHERE `status` = 1 LIMIT 1 [ RunTime:0.003591s ]
SELECT `id`,`pic`,`title`,`time`,`description` FROM `shop_newsinfo` WHERE `status` = 1 ORDER BY `time` DESC LIMIT 0,6 [ RunTime:0.000828s ]
SELECT `id`,`pic`,`title`,`time`,`description` FROM `shop_newsinfo` WHERE `flag` = 'h' AND `status` = 1 ORDER BY `time` DESC [ RunTime:0.000648s ]
SHOW FULL COLUMNS FROM `shop_fgsinfo` [ RunTime:0.007625s ]
SELECT * FROM `shop_fgsinfo` WHERE `status` = 1 ORDER BY `time` DESC [ RunTime:0.002760s ]
SHOW FULL COLUMNS FROM `shop_usatype` [ RunTime:0.003764s ]
SELECT `smid`,`type` FROM `shop_usatype` [ RunTime:0.000957s ]
SHOW FULL COLUMNS FROM `shop_usainfo` [ RunTime:0.003767s ]
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.002708s ]