[ DB ] CONNECT:[ UseTime:0.000288s ] mysql:host=localhost;port=3306;dbname=91chuangye;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.000771s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `parent_id` IN (52,53) AND ( status =1 and ishidden = 1 ) [ RunTime:0.000283s ]
[ SQL ] SELECT `id`,`parent_id` FROM `cmf_portal_category` WHERE `path` = 'qiche' LIMIT 1 [ RunTime:0.000160s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `path` = 'qiche' LIMIT 1 [ RunTime:0.000190s ]
[ SQL ] SELECT `id`,`path`,`name`,`parent_id` FROM `cmf_portal_category` WHERE `status` = 1 AND `ishidden` = 1 AND `path` = 'qiche' LIMIT 1 [ RunTime:0.000136s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `status` = 1 AND `ishidden` = 1 AND `parent_id` = 6 [ RunTime:0.000132s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_xm` [ RunTime:0.000773s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_portal_xm` `por` INNER JOIN `cmf_portal_category` `cat` ON `por`.`typeid`=`cat`.`id` WHERE `por`.`typeid` IN (128,130,131,133,134,136,137,138,140,142,143,145,146,148,149,151,152) AND `por`.`litpic` <> '/uploads/jd/qjnone.gif' AND `por`.`status` = 1 AND `por`.`arcrank` = 1 LIMIT 1 [ RunTime:0.003398s ]
[ SQL ] SELECT `por`.`aid`,`por`.`class`,`por`.`litpic`,`por`.`thumbnail`,`por`.`title`,`por`.`sum`,`por`.`invested`,`por`.`companyname`,`por`.`address`,`por`.`nativeplace`,cat.name as categoryname,`cat`.`path`,`por`.`description`,`por`.`jieshao` FROM `cmf_portal_xm` `por` INNER JOIN `cmf_portal_category` `cat` ON `por`.`typeid`=`cat`.`id` WHERE `por`.`typeid` IN (128,130,131,133,134,136,137,138,140,142,143,145,146,148,149,151,152) AND `por`.`litpic` <> '/uploads/jd/qjnone.gif' AND `por`.`status` = 1 AND `por`.`arcrank` = 1 ORDER BY `update_time` DESC LIMIT 0,20 [ RunTime:0.003348s ]
[ SQL ] SHOW COLUMNS FROM `cmf_sys_enum` [ RunTime:0.000483s ]
[ SQL ] SELECT `ename`,`py` FROM `cmf_sys_enum` WHERE ( evalue = 3000 and py != '' ) LIMIT 1 [ RunTime:0.000194s ]
[ SQL ] SELECT `ename`,`py` FROM `cmf_sys_enum` WHERE ( evalue = 2500 and py != '' ) LIMIT 1 [ RunTime:0.000154s ]
[ SQL ] SELECT `ename`,`py` FROM `cmf_sys_enum` WHERE ( evalue = 2500 and py != '' ) LIMIT 1 [ RunTime:0.000114s ]
[ SQL ] SELECT `ename`,`py` FROM `cmf_sys_enum` WHERE ( evalue = 1500 and py != '' ) LIMIT 1 [ RunTime:0.000120s ]
[ SQL ] SELECT `ename`,`py` FROM `cmf_sys_enum` WHERE ( evalue = 1000 and py != '' ) LIMIT 1 [ RunTime:0.000110s ]
[ SQL ] SELECT `ename`,`py` FROM `cmf_sys_enum` WHERE ( evalue = 1000 and py != '' ) LIMIT 1 [ RunTime:0.000108s ]
[ SQL ] SELECT `ename`,`py` FROM `cmf_sys_enum` WHERE ( evalue = 7000 and py != '' ) LIMIT 1 [ RunTime:0.000110s ]
[ SQL ] SELECT `ename`,`py` FROM `cmf_sys_enum` WHERE ( evalue = 4000 and py != '' ) LIMIT 1 [ RunTime:0.000110s ]
[ SQL ] SELECT `ename`,`py` FROM `cmf_sys_enum` WHERE ( evalue = 10500 and py != '' ) LIMIT 1 [ RunTime:0.000112s ]
[ SQL ] SELECT `ename`,`py` FROM `cmf_sys_enum` WHERE ( evalue = 9502 and py != '' ) LIMIT 1 [ RunTime:0.000120s ]
[ SQL ] SELECT `ename`,`py` FROM `cmf_sys_enum` WHERE ( evalue = 2500 and py != '' ) LIMIT 1 [ RunTime:0.000112s ]
[ SQL ] SELECT `ename`,`py` FROM `cmf_sys_enum` WHERE ( evalue = 10500 and py != '' ) LIMIT 1 [ RunTime:0.000111s ]
[ SQL ] SELECT `ename`,`py` FROM `cmf_sys_enum` WHERE ( evalue = 3500 and py != '' ) LIMIT 1 [ RunTime:0.000109s ]
[ SQL ] SELECT `ename`,`py` FROM `cmf_sys_enum` WHERE ( evalue = 500 and py != '' ) LIMIT 1 [ RunTime:0.000108s ]
[ SQL ] SELECT `ename`,`py` FROM `cmf_sys_enum` WHERE ( evalue = 5500 and py != '' ) LIMIT 1 [ RunTime:0.000110s ]
[ SQL ] SELECT `ename`,`py` FROM `cmf_sys_enum` WHERE ( evalue = 1000 and py != '' ) LIMIT 1 [ RunTime:0.000108s ]
[ SQL ] SELECT `ename`,`py` FROM `cmf_sys_enum` WHERE ( evalue = 2500 and py != '' ) LIMIT 1 [ RunTime:0.000108s ]
[ SQL ] SELECT `ename`,`py` FROM `cmf_sys_enum` WHERE ( evalue = 4500 and py != '' ) LIMIT 1 [ RunTime:0.000120s ]
[ SQL ] SELECT `ename`,`py` FROM `cmf_sys_enum` WHERE ( evalue = 1505 and py != '' ) LIMIT 1 [ RunTime:0.000189s ]
[ SQL ] SELECT `ename`,`py` FROM `cmf_sys_enum` WHERE ( evalue = 500 and py != '' ) LIMIT 1 [ RunTime:0.000173s ]
[ SQL ] SELECT `ename` FROM `cmf_sys_enum` WHERE `py` = '' LIMIT 1 [ RunTime:0.000123s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE ( path='qiche' and status = 1 and ishidden = 1 ) LIMIT 1 [ RunTime:0.000169s ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE ( path='qiche' ) LIMIT 1 [ RunTime:0.000118s ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE ( path='qiche' ) LIMIT 1 [ RunTime:0.000107s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `name` = '汽車加盟資訊' AND `parent_id` = 399 LIMIT 1 [ RunTime:0.000141s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.000635s ]
[ SQL ] SELECT `id`,`post_title`,`class`,`published_time`,`create_time` FROM `cmf_portal_post` WHERE `status` = '1' AND `post_status` = 1 AND `parent_id` = 406 ORDER BY `published_time` DESC LIMIT 10 [ RunTime:0.012443s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `name` = '汽車加盟' AND `parent_id` = 391 LIMIT 1 [ RunTime:0.000251s ]
[ SQL ] SELECT `id`,`name`,`path` FROM `cmf_portal_category` WHERE `name` = '汽車加盟' AND `parent_id` = 382 LIMIT 1 [ RunTime:0.000145s ]
[ SQL ] SELECT `id`,`name`,`path` FROM `cmf_portal_category` WHERE `parent_id` = 382 ORDER BY `list_order` ASC LIMIT 10 [ RunTime:0.000141s ]
[ SQL ] SELECT `aid`,`title`,`class`,`invested`,`litpic`,`click`,`sum` FROM `cmf_portal_xm` WHERE `status` = 1 AND `arcrank` = '1' ORDER BY `click` DESC LIMIT 5,4 [ RunTime:0.152618s ]
[ SQL ] SELECT `aid`,`typeid`,`title`,`class`,`invested` FROM `cmf_portal_xm` WHERE `status` = 1 AND `arcrank` = '1' ORDER BY `weight` DESC LIMIT 10 [ RunTime:0.159993s ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE ( id = 292 ) LIMIT 1 [ RunTime:0.000209s ]
[ SQL ] SELECT `path` FROM `cmf_portal_category` WHERE ( name like '中式快餐加盟' and id > 391 ) LIMIT 1 [ RunTime:0.000132s ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE ( id = 153 ) LIMIT 1 [ RunTime:0.000108s ]
[ SQL ] SELECT `path` FROM `cmf_portal_category` WHERE ( name like '火鍋加盟' and id > 391 ) LIMIT 1 [ RunTime:0.000109s ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE ( id = 173 ) LIMIT 1 [ RunTime:0.000110s ]
[ SQL ] SELECT `path` FROM `cmf_portal_category` WHERE ( name like '快餐加盟' and id > 391 ) LIMIT 1 [ RunTime:0.000118s ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE ( id = 181 ) LIMIT 1 [ RunTime:0.000103s ]
[ SQL ] SELECT `path` FROM `cmf_portal_category` WHERE ( name like '麻辣燙加盟' and id > 391 ) LIMIT 1 [ RunTime:0.000107s ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE ( id = 289 ) LIMIT 1 [ RunTime:0.000102s ]
[ SQL ] SELECT `path` FROM `cmf_portal_category` WHERE ( name like '魚火鍋加盟' and id > 391 ) LIMIT 1 [ RunTime:0.000105s ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE ( id = 190 ) LIMIT 1 [ RunTime:0.000119s ]
[ SQL ] SELECT `path` FROM `cmf_portal_category` WHERE ( name like '面包加盟' and id > 391 ) LIMIT 1 [ RunTime:0.000109s ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE ( id = 181 ) LIMIT 1 [ RunTime:0.000104s ]
[ SQL ] SELECT `path` FROM `cmf_portal_category` WHERE ( name like '麻辣燙加盟' and id > 391 ) LIMIT 1 [ RunTime:0.000108s ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE ( id = 288 ) LIMIT 1 [ RunTime:0.000107s ]
[ SQL ] SELECT `path` FROM `cmf_portal_category` WHERE ( name like '飲品加盟' and id > 391 ) LIMIT 1 [ RunTime:0.000106s ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE ( id = 243 ) LIMIT 1 [ RunTime:0.000108s ]
[ SQL ] SELECT `path` FROM `cmf_portal_category` WHERE ( name like '壽司加盟' and id > 391 ) LIMIT 1 [ RunTime:0.000108s ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE ( id = 80 ) LIMIT 1 [ RunTime:0.000105s ]
[ SQL ] SELECT `path` FROM `cmf_portal_category` WHERE ( name like '冰淇淋加盟' and id > 391 ) LIMIT 1 [ RunTime:0.000107s ]
[ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `status` = 1 AND `ishidden` = 1 AND `parent_id` = 6 [ RunTime:0.000150s ]
[ SQL ] SELECT `aid`,`typeid`,`title`,`class`,`invested`,`litpic` FROM `cmf_portal_xm` WHERE `status` = 1 AND `arcrank` = '1' AND `typeid` IN (128,130,131,133,134,136,137,138,140,142,143,145,146,148,149,151,152) AND `litpic` <> ' ' ORDER BY `click` DESC LIMIT 30,3 [ RunTime:0.003684s ]
[ SQL ] SHOW COLUMNS FROM `cmf_html` [ RunTime:0.000539s ]
[ SQL ] SELECT * FROM `cmf_html` WHERE `path` = 'public/qiche' LIMIT 1 [ RunTime:0.000239s ]
