[ DB ] CONNECT:[ UseTime:0.000213s ] mysql:host=localhost;port=10005;dbname=yzw_mushang_cc;charset=utf8
[ SQL ] SHOW COLUMNS FROM `fa_area` [ RunTime:0.000383s ]
[ SQL ] SELECT `id`,`name` FROM `fa_area` WHERE `pid` = 0 LIMIT 30 [ RunTime:0.000100s ]
[ SQL ] SHOW COLUMNS FROM `fa_industry` [ RunTime:0.000345s ]
[ SQL ] SELECT * FROM `fa_industry` WHERE `status` = 'normal' ORDER BY `weigh` DESC LIMIT 18 [ RunTime:0.000104s ]
[ SQL ] SELECT * FROM `fa_industry` WHERE `status` = 'normal' AND `commend` = 1 ORDER BY `weigh` DESC [ RunTime:0.000367s ]
[ SQL ] SHOW COLUMNS FROM `fa_shangbiaocate` [ RunTime:0.000324s ]
[ SQL ] SELECT * FROM `fa_shangbiaocate` WHERE `status` = 'normal' AND `recommend` = 1 ORDER BY `weigh` DESC [ RunTime:0.000102s ]
[ SQL ] SHOW COLUMNS FROM `fa_company` [ RunTime:0.000500s ]
[ SQL ] SELECT * FROM `fa_company` WHERE `status` = 'normal' AND `recommend` = 1 LIMIT 2 [ RunTime:0.000232s ]
[ SQL ] SHOW COLUMNS FROM `fa_shangbiao` [ RunTime:0.000636s ]
[ SQL ] SELECT * FROM `fa_shangbiao` WHERE `status` = 'normal' AND `recommend` = 1 LIMIT 2 [ RunTime:0.000215s ]
[ SQL ] SHOW COLUMNS FROM `fa_buy` [ RunTime:0.000349s ]
[ SQL ] SELECT * FROM `fa_buy` WHERE `status` = 'normal' AND `recommend` = 1 LIMIT 2 [ RunTime:0.000133s ]
[ SQL ] SHOW COLUMNS FROM `fa_commission` [ RunTime:0.000321s ]
[ SQL ] SHOW COLUMNS FROM `fa_user` [ RunTime:0.000351s ]
[ SQL ] SELECT `commission`.`id`,`commission`.`user_id`,`commission`.`title`,`commission`.`image`,`commission`.`province_id`,`commission`.`city_id`,`commission`.`area_id`,`commission`.`service_ids`,`commission`.`content`,`commission`.`phone`,`commission`.`contacts`,`commission`.`status`,`commission`.`createtime`,`commission`.`updatetime`,`commission`.`views`,`commission`.`memo`,`commission`.`toptime`,`commission`.`topstatus`,`commission`.`reloadtime`,user.id AS user__id,user.group_id AS user__group_id,user.username AS user__username,user.nickname AS user__nickname,user.password AS user__password,user.salt AS user__salt,user.email AS user__email,user.mobile AS user__mobile,user.avatar AS user__avatar,user.level AS user__level,user.gender AS user__gender,user.birthday AS user__birthday,user.bio AS user__bio,user.money AS user__money,user.score AS user__score,user.successions AS user__successions,user.maxsuccessions AS user__maxsuccessions,user.prevtime AS user__prevtime,user.logintime AS user__logintime,user.loginip AS user__loginip,user.loginfailure AS user__loginfailure,user.joinip AS user__joinip,user.jointime AS user__jointime,user.createtime AS user__createtime,user.updatetime AS user__updatetime,user.token AS user__token,user.status AS user__status,user.verification AS user__verification,user.is_real AS user__is_real,user.wechat_img AS user__wechat_img,user.qq AS user__qq,user.wechat_num AS user__wechat_num,user.staff AS user__staff,user.staff_name AS user__staff_name,user.revisit_status AS user__revisit_status,user.rotation_waiter AS user__rotation_waiter,user.work_wechat_qrcode AS user__work_wechat_qrcode FROM `fa_commission` `commission` LEFT JOIN `fa_user` `user` ON `commission`.`user_id`=`user`.`id` WHERE `commission`.`status` = 'normal' AND `user`.`is_real` = 2 LIMIT 2 [ RunTime:0.000238s ]
[ SQL ] SHOW COLUMNS FROM `fa_service` [ RunTime:0.000317s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000083s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 9 LIMIT 1 [ RunTime:0.000074s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 23 LIMIT 1 [ RunTime:0.000065s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000064s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 6 LIMIT 1 [ RunTime:0.000061s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000062s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 44 LIMIT 1 [ RunTime:0.000062s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 53 LIMIT 1 [ RunTime:0.000077s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 55 LIMIT 1 [ RunTime:0.000065s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 56 LIMIT 1 [ RunTime:0.000072s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000064s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 58 LIMIT 1 [ RunTime:0.000080s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000158s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 10 LIMIT 1 [ RunTime:0.000086s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 11 LIMIT 1 [ RunTime:0.000083s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000067s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 13 LIMIT 1 [ RunTime:0.000076s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000064s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 15 LIMIT 1 [ RunTime:0.000063s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000062s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 17 LIMIT 1 [ RunTime:0.000062s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 25 LIMIT 1 [ RunTime:0.000061s ]
[ SQL ] SHOW COLUMNS FROM `fa_type` [ RunTime:0.000323s ]
[ SQL ] SELECT * FROM `fa_type` WHERE `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.000113s ]
[ SQL ] SHOW COLUMNS FROM `fa_label` [ RunTime:0.000292s ]
[ SQL ] SELECT * FROM `fa_label` WHERE `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.000091s ]
[ SQL ] SHOW COLUMNS FROM `fa_category` [ RunTime:0.000261s ]
[ SQL ] SELECT * FROM `fa_category` WHERE `pid` = 0 ORDER BY `weigh` DESC [ RunTime:0.000105s ]
[ SQL ] SHOW COLUMNS FROM `fa_regyear` [ RunTime:0.000295s ]
[ SQL ] SELECT * FROM `fa_regyear` WHERE `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.000088s ]
[ SQL ] SHOW COLUMNS FROM `fa_regcap` [ RunTime:0.000293s ]
[ SQL ] SELECT * FROM `fa_regcap` WHERE `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.000094s ]
[ SQL ] SHOW COLUMNS FROM `fa_taxnat` [ RunTime:0.000257s ]
[ SQL ] SELECT * FROM `fa_taxnat` WHERE `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.000085s ]
[ SQL ] SELECT * FROM `fa_industry` WHERE `status` = 'normal' ORDER BY `weigh` DESC LIMIT 6 [ RunTime:0.000084s ]
[ SQL ] SHOW COLUMNS FROM `fa_buyzizhi` [ RunTime:0.000285s ]
[ SQL ] SELECT * FROM `fa_buyzizhi` WHERE `status` = 'normal' LIMIT 6 [ RunTime:0.000087s ]
[ SQL ] SELECT * FROM `fa_shangbiaocate` WHERE `status` = 'normal' ORDER BY `code` ASC LIMIT 6 [ RunTime:0.000089s ]
[ SQL ] SELECT * FROM `fa_service` WHERE `pid` = 0 AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.000095s ]
[ SQL ] SELECT * FROM `fa_shangbiaocate` WHERE `status` = 'normal' ORDER BY `code` ASC LIMIT 18 [ RunTime:0.000104s ]
[ SQL ] SHOW COLUMNS FROM `fa_shangbiaotype` [ RunTime:0.000271s ]
[ SQL ] SELECT * FROM `fa_shangbiaotype` WHERE `status` = 'normal' ORDER BY `id` ASC [ RunTime:0.000089s ]
[ SQL ] SHOW COLUMNS FROM `fa_shangbiaolength` [ RunTime:0.000269s ]
[ SQL ] SELECT * FROM `fa_shangbiaolength` WHERE `status` = 'normal' ORDER BY `id` ASC [ RunTime:0.000107s ]
[ SQL ] SHOW COLUMNS FROM `fa_shangbiaopricerange` [ RunTime:0.000270s ]
[ SQL ] SELECT * FROM `fa_shangbiaopricerange` WHERE `status` = 'normal' ORDER BY `id` ASC [ RunTime:0.000089s ]
[ SQL ] SHOW COLUMNS FROM `fa_shangbiaoregyear` [ RunTime:0.000282s ]
[ SQL ] SELECT * FROM `fa_shangbiaoregyear` WHERE `status` = 'normal' ORDER BY `id` ASC [ RunTime:0.000110s ]
[ SQL ] SELECT * FROM `fa_shangbiaopricerange` WHERE `status` = 'normal' ORDER BY `id` ASC LIMIT 6 [ RunTime:0.000090s ]
[ SQL ] SHOW COLUMNS FROM `fa_blogroll` [ RunTime:0.000275s ]
[ SQL ] SELECT * FROM `fa_blogroll` [ RunTime:0.000089s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fa_company` WHERE `user_id` = 27 AND `status` = 'normal' LIMIT 1 [ RunTime:0.004163s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fa_buy` WHERE `user_id` = 27 LIMIT 1 [ RunTime:0.000520s ]
[ SQL ] SELECT * FROM `fa_user` WHERE `id` = 27 LIMIT 1 [ RunTime:0.000169s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fa_commission` WHERE `user_id` = 27 LIMIT 1 [ RunTime:0.000433s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fa_commission` WHERE `user_id` = 27 AND `status` = 'normal' LIMIT 1 [ RunTime:0.000204s ]
[ SQL ] SELECT * FROM `fa_commission` WHERE `user_id` = 27 AND `status` = 'normal' ORDER BY `updatetime` DESC LIMIT 0,10 [ RunTime:0.000222s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 4 LIMIT 1 [ RunTime:0.000116s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 17 LIMIT 1 [ RunTime:0.000130s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000094s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000080s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000080s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000100s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 6 LIMIT 1 [ RunTime:0.000096s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 9 LIMIT 1 [ RunTime:0.000074s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000065s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000071s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 6 LIMIT 1 [ RunTime:0.000068s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000060s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 4 LIMIT 1 [ RunTime:0.000060s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000074s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 17 LIMIT 1 [ RunTime:0.000072s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000075s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 15 LIMIT 1 [ RunTime:0.000062s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000153s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 13 LIMIT 1 [ RunTime:0.000164s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000096s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 11 LIMIT 1 [ RunTime:0.000064s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 10 LIMIT 1 [ RunTime:0.000140s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 9 LIMIT 1 [ RunTime:0.000604s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000069s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000150s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 6 LIMIT 1 [ RunTime:0.000106s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000154s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000089s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000106s ]
[ SQL ] SELECT `name` FROM `fa_service` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000134s ]
[ SQL ] SELECT * FROM `fa_industry` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000391s ]
[ SQL ] SELECT * FROM `fa_area` WHERE `id` = 1532 LIMIT 1 [ RunTime:0.000102s ]
[ SQL ] SELECT * FROM `fa_area` WHERE `id` = 1532 LIMIT 1 [ RunTime:0.000136s ]
[ SQL ] SELECT * FROM `fa_area` WHERE `id` = 1533 LIMIT 1 [ RunTime:0.000122s ]
[ SQL ] SELECT * FROM `fa_area` WHERE `id` = 1532 LIMIT 1 [ RunTime:0.000100s ]
[ SQL ] SELECT * FROM `fa_area` WHERE `id` = 1532 LIMIT 1 [ RunTime:0.000123s ]
[ SQL ] SELECT * FROM `fa_area` WHERE `id` = 1533 LIMIT 1 [ RunTime:0.000129s ]
[ SQL ] SELECT * FROM `fa_industry` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000114s ]
[ SQL ] SELECT * FROM `fa_area` WHERE `id` = 1532 LIMIT 1 [ RunTime:0.000105s ]
[ SQL ] SELECT * FROM `fa_area` WHERE `id` = 1532 LIMIT 1 [ RunTime:0.000138s ]
[ SQL ] SELECT * FROM `fa_area` WHERE `id` = 1533 LIMIT 1 [ RunTime:0.000106s ]
[ SQL ] SELECT * FROM `fa_area` WHERE `id` = 1532 LIMIT 1 [ RunTime:0.000089s ]
[ SQL ] SELECT * FROM `fa_area` WHERE `id` = 1532 LIMIT 1 [ RunTime:0.000071s ]
[ SQL ] SELECT * FROM `fa_area` WHERE `id` = 1533 LIMIT 1 [ RunTime:0.000087s ]
[ SQL ] SELECT * FROM `fa_area` WHERE `id` = 1532 LIMIT 1 [ RunTime:0.000099s ]
[ SQL ] SELECT * FROM `fa_area` WHERE `id` = 1532 LIMIT 1 [ RunTime:0.000498s ]
[ SQL ] SELECT * FROM `fa_area` WHERE `id` = 1533 LIMIT 1 [ RunTime:0.000104s ]
[ SQL ] SELECT * FROM `fa_area` WHERE `id` = 1532 LIMIT 1 [ RunTime:0.000129s ]
[ SQL ] SELECT * FROM `fa_area` WHERE `id` = 1532 LIMIT 1 [ RunTime:0.000201s ]
[ SQL ] SELECT * FROM `fa_area` WHERE `id` = 1533 LIMIT 1 [ RunTime:0.000108s ]
[ SQL ] SELECT * FROM `fa_shangbiaocate` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000133s ]
[ SQL ] SELECT * FROM `fa_shangbiaotype` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000148s ]
[ SQL ] SELECT * FROM `fa_shangbiaocate` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000125s ]
[ SQL ] SELECT * FROM `fa_shangbiaotype` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000118s ]
[ SQL ] SELECT * FROM `fa_area` WHERE `id` = 1532 LIMIT 1 [ RunTime:0.000113s ]
[ SQL ] SELECT * FROM `fa_area` WHERE `id` = 1532 LIMIT 1 [ RunTime:0.000159s ]
[ SQL ] SELECT * FROM `fa_area` WHERE `id` = 1533 LIMIT 1 [ RunTime:0.000174s ]
[ SQL ] SELECT * FROM `fa_area` WHERE `id` = 1538 LIMIT 1 [ RunTime:0.000124s ]
[ SQL ] SELECT * FROM `fa_area` WHERE `id` = 1532 LIMIT 1 [ RunTime:0.000149s ]
[ SQL ] SELECT * FROM `fa_area` WHERE `id` = 1532 LIMIT 1 [ RunTime:0.000151s ]
[ SQL ] SELECT * FROM `fa_area` WHERE `id` = 1533 LIMIT 1 [ RunTime:0.000108s ]
[ SQL ] SELECT * FROM `fa_area` WHERE `id` = 1537 LIMIT 1 [ RunTime:0.000100s ]
[ SQL ] SELECT * FROM `fa_area` WHERE `id` = 1532 LIMIT 1 [ RunTime:0.000079s ]
[ SQL ] SELECT * FROM `fa_area` WHERE `id` = 1532 LIMIT 1 [ RunTime:0.000116s ]
[ SQL ] SELECT * FROM `fa_area` WHERE `id` = 1533 LIMIT 1 [ RunTime:0.000115s ]
[ SQL ] SELECT * FROM `fa_area` WHERE `id` = 1537 LIMIT 1 [ RunTime:0.000152s ]
[ SQL ] SELECT * FROM `fa_area` WHERE `id` = 1532 LIMIT 1 [ RunTime:0.000118s ]
[ SQL ] SELECT * FROM `fa_area` WHERE `id` = 1532 LIMIT 1 [ RunTime:0.000092s ]
[ SQL ] SELECT * FROM `fa_area` WHERE `id` = 1533 LIMIT 1 [ RunTime:0.000117s ]
[ SQL ] SELECT * FROM `fa_area` WHERE `id` = 1537 LIMIT 1 [ RunTime:0.000205s ]