[ DB ] CONNECT:[ UseTime:0.000256s ] mysql:host=localhost;port=3306;dbname=91chuangye;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.000794s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `parent_id` IN (52,53) AND ( status =1 and ishidden = 1 ) [ RunTime:0.000318s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_xm` [ RunTime:0.000823s ]
[ SQL ] SELECT `aid`,`title`,`class` FROM `cmf_portal_xm` `por` WHERE `por`.`typeid` NOT IN ('350','63','391','432') AND ( status = 1 and arcrank = 1 ) ORDER BY `aid` DESC LIMIT 50 [ RunTime:0.000731s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_portal_xm` `por` INNER JOIN `cmf_portal_category` `cat` ON `por`.`typeid`=`cat`.`id` WHERE `por`.`invested` = '100-200萬' AND `cat`.`parent_id` NOT IN ('350','63','391','432') AND `por`.`typeid` NOT IN ('350','63','391','432') AND `por`.`litpic` <> '/uploads/jd/qjnone.gif' AND `por`.`status` = 1 AND `por`.`arcrank` = 1 LIMIT 1 [ RunTime:0.159631s ]
[ 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`.`invested` = '100-200萬' AND `cat`.`parent_id` NOT IN ('350','63','391','432') AND `por`.`typeid` NOT IN ('350','63','391','432') 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.020871s ]
[ SQL ] SHOW COLUMNS FROM `cmf_sys_enum` [ RunTime:0.000633s ]
[ SQL ] SELECT `ename`,`py` FROM `cmf_sys_enum` WHERE ( evalue = 3500 and py != '' ) LIMIT 1 [ RunTime:0.000149s ]
[ SQL ] SELECT `ename`,`py` FROM `cmf_sys_enum` WHERE ( evalue = 3501 and py != '' ) LIMIT 1 [ RunTime:0.000117s ]
[ SQL ] SELECT `ename`,`py` FROM `cmf_sys_enum` WHERE ( evalue = 500 and py != '' ) LIMIT 1 [ RunTime:0.000112s ]
[ SQL ] SELECT `ename`,`py` FROM `cmf_sys_enum` WHERE ( evalue = 4502 and py != '' ) LIMIT 1 [ RunTime:0.000114s ]
[ SQL ] SELECT `ename`,`py` FROM `cmf_sys_enum` WHERE ( evalue = 2501 and py != '' ) LIMIT 1 [ RunTime:0.000109s ]
[ SQL ] SELECT `ename`,`py` FROM `cmf_sys_enum` WHERE ( evalue = 1000 and py != '' ) LIMIT 1 [ RunTime:0.000102s ]
[ SQL ] SELECT `ename`,`py` FROM `cmf_sys_enum` WHERE ( evalue = 6000 and py != '' ) LIMIT 1 [ RunTime:0.000109s ]
[ SQL ] SELECT `ename`,`py` FROM `cmf_sys_enum` WHERE ( evalue = 2500 and py != '' ) LIMIT 1 [ RunTime:0.000101s ]
[ SQL ] SELECT `ename`,`py` FROM `cmf_sys_enum` WHERE ( evalue = 2500 and py != '' ) LIMIT 1 [ RunTime:0.000103s ]
[ SQL ] SELECT `ename`,`py` FROM `cmf_sys_enum` WHERE ( evalue = 2500 and py != '' ) LIMIT 1 [ RunTime:0.000102s ]
[ SQL ] SELECT `ename`,`py` FROM `cmf_sys_enum` WHERE ( evalue = 3500 and py != '' ) LIMIT 1 [ RunTime:0.000125s ]
[ SQL ] SELECT `ename`,`py` FROM `cmf_sys_enum` WHERE ( evalue = 2501 and py != '' ) LIMIT 1 [ RunTime:0.000111s ]
[ SQL ] SELECT `ename`,`py` FROM `cmf_sys_enum` WHERE ( evalue = 500 and py != '' ) LIMIT 1 [ RunTime:0.000101s ]
[ SQL ] SELECT `ename`,`py` FROM `cmf_sys_enum` WHERE ( evalue = 4001 and py != '' ) LIMIT 1 [ RunTime:0.000104s ]
[ SQL ] SELECT `ename`,`py` FROM `cmf_sys_enum` WHERE ( evalue = 2501 and py != '' ) LIMIT 1 [ RunTime:0.000101s ]
[ SQL ] SELECT `ename`,`py` FROM `cmf_sys_enum` WHERE ( evalue = 3506 and py != '' ) LIMIT 1 [ RunTime:0.000109s ]
[ SQL ] SELECT `ename`,`py` FROM `cmf_sys_enum` WHERE ( evalue = 1000 and py != '' ) LIMIT 1 [ RunTime:0.000105s ]
[ SQL ] SELECT `ename` FROM `cmf_sys_enum` WHERE `py` = '' LIMIT 1 [ RunTime:0.000126s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE ( path='xiangmu' and status = 1 and ishidden = 1 ) LIMIT 1 [ RunTime:0.000169s ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE ( path='xiangmu' ) LIMIT 1 [ RunTime:0.000108s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.000633s ]
[ SQL ] SELECT `id`,`post_title`,`class`,`published_time`,`create_time` FROM `cmf_portal_post` WHERE `status` = '1' AND `post_status` = 1 ORDER BY `published_time` DESC LIMIT 10 [ RunTime:0.000315s ]
[ SQL ] SELECT `id`,`name`,`path` FROM `cmf_portal_category` WHERE `parent_id` = 391 ORDER BY `list_order` ASC LIMIT 10 [ RunTime:0.000186s ]
[ SQL ] SELECT `aid`,`class`,`litpic`,`title`,`thumbnail` FROM `cmf_portal_xm` WHERE `status` = 1 AND `arcrank` = '1' AND `aid` IN (1169,86522,90909,119539,119502) ORDER BY `click` DESC LIMIT 5 [ RunTime:0.000472s ]
[ 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.000153s ]
[ 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.000141s ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE ( id = 292 ) LIMIT 1 [ RunTime:0.000111s ]
[ SQL ] SELECT `path` FROM `cmf_portal_category` WHERE ( name like '中式快餐加盟' and id > 391 ) LIMIT 1 [ RunTime:0.000125s ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE ( id = 153 ) LIMIT 1 [ RunTime:0.000109s ]
[ SQL ] SELECT `path` FROM `cmf_portal_category` WHERE ( name like '火鍋加盟' and id > 391 ) LIMIT 1 [ RunTime:0.000100s ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE ( id = 173 ) LIMIT 1 [ RunTime:0.000105s ]
[ SQL ] SELECT `path` FROM `cmf_portal_category` WHERE ( name like '快餐加盟' and id > 391 ) LIMIT 1 [ RunTime:0.000098s ]
[ 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.000102s ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE ( id = 289 ) LIMIT 1 [ RunTime:0.000108s ]
[ SQL ] SELECT `path` FROM `cmf_portal_category` WHERE ( name like '魚火鍋加盟' and id > 391 ) LIMIT 1 [ RunTime:0.000111s ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE ( id = 190 ) LIMIT 1 [ RunTime:0.000108s ]
[ SQL ] SELECT `path` FROM `cmf_portal_category` WHERE ( name like '面包加盟' and id > 391 ) LIMIT 1 [ RunTime:0.000117s ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE ( id = 181 ) LIMIT 1 [ RunTime:0.000109s ]
[ 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 = 288 ) LIMIT 1 [ RunTime:0.000112s ]
[ 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 = 243 ) LIMIT 1 [ RunTime:0.000113s ]
[ SQL ] SELECT `path` FROM `cmf_portal_category` WHERE ( name like '壽司加盟' and id > 391 ) LIMIT 1 [ RunTime:0.000116s ]
[ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE ( id = 80 ) LIMIT 1 [ RunTime:0.000109s ]
[ SQL ] SELECT `path` FROM `cmf_portal_category` WHERE ( name like '冰淇淋加盟' and id > 391 ) LIMIT 1 [ RunTime:0.000110s ]
[ SQL ] SELECT `aid`,`typeid`,`title`,`class`,`invested`,`litpic` FROM `cmf_portal_xm` WHERE `status` = 1 AND `arcrank` = '1' AND `litpic` <> ' ' ORDER BY `click` DESC LIMIT 30,3 [ RunTime:0.153845s ]
