SHOW FULL COLUMNS FROM `shop_productinfo` [ RunTime:0.018129s ]
SELECT `id`,`title`,`pic`,`contentinfo` FROM `shop_productinfo` WHERE `price` = 'y' AND `status` >= 1 ORDER BY `id` ASC [ RunTime:0.038881s ]
SHOW FULL COLUMNS FROM `shop_scriptinfo` [ RunTime:0.001692s ]
SELECT `address`,`mobile`,`email` FROM `shop_scriptinfo` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001751s ]
SELECT `copyright`,`it` FROM `shop_scriptinfo` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000262s ]
SELECT `lphone`,`qq`,`email` FROM `shop_scriptinfo` WHERE `id` = 4 LIMIT 1 [ RunTime:0.000272s ]
SELECT `contentinfo` FROM `shop_scriptinfo` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000241s ]
SHOW FULL COLUMNS FROM `shop_otherbenefits` [ RunTime:0.001385s ]
SELECT `working`,`benefits`,`activities`,`growth`,`environment`,`otherbenefits` FROM `shop_otherbenefits` WHERE `id` = 5 LIMIT 1 [ RunTime:0.001616s ]
SHOW FULL COLUMNS FROM `shop_newsinfoen` [ RunTime:0.001391s ]
SELECT `id`,`title`,`pic`,`time` FROM `shop_newsinfoen` LIMIT 6 [ RunTime:0.000339s ]
SHOW FULL COLUMNS FROM `shop_newsinfo` [ RunTime:0.001357s ]
SELECT `id`,`pic`,`title`,`time`,`description` FROM `shop_newsinfo` WHERE `flag` = 't' AND `status` = 1 ORDER BY `time` DESC LIMIT 1 [ RunTime:0.010025s ]
SELECT COUNT(*) AS think_count FROM `shop_newsinfo` WHERE `status` = 1 LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`pic`,`title`,`time`,`description` FROM `shop_newsinfo` WHERE `status` = 1 ORDER BY `time` DESC LIMIT 42,6 [ RunTime:0.000472s ]
SELECT `id`,`pic`,`title`,`time`,`description` FROM `shop_newsinfo` WHERE `flag` = 'h' AND `status` = 1 ORDER BY `time` DESC [ RunTime:0.000521s ]
SHOW FULL COLUMNS FROM `shop_fgsinfo` [ RunTime:0.002401s ]
SELECT * FROM `shop_fgsinfo` WHERE `status` = 1 ORDER BY `time` DESC [ RunTime:0.007693s ]
SHOW FULL COLUMNS FROM `shop_usatype` [ RunTime:0.001314s ]
SELECT `smid`,`type` FROM `shop_usatype` [ RunTime:0.001511s ]
SHOW FULL COLUMNS FROM `shop_usainfo` [ RunTime:0.001349s ]
SELECT * FROM `shop_usainfo` `a` INNER JOIN `shop_usatype` `w` ON `a`.`p_smid`=`w`.`smid` WHERE `status` = 1 AND `p_smid` = 1 ORDER BY `a`.`time` DESC [ RunTime:0.024060s ]