[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_project_question` `a` INNER JOIN `cmf_project_answer` `b` ON `b`.`id`=`a`.`answer_id` LEFT JOIN `cmf_portal_category` `c` ON `c`.`id`=`a`.`cate_id` WHERE `a`.`status` = 2 AND `a`.`accept_user_id` = 143 [ RunTime:0.000341s ]
[ SQL ] SELECT `a`.*,b.id as b_id,b.content as answer,`b`.`like_num`,c.name as cate_name FROM `cmf_project_question` `a` INNER JOIN `cmf_project_answer` `b` ON `b`.`id`=`a`.`answer_id` LEFT JOIN `cmf_portal_category` `c` ON `c`.`id`=`a`.`cate_id` WHERE `a`.`status` = 2 AND `a`.`accept_user_id` = 143 LIMIT 0,3 [ RunTime:0.000353s ]
[ SQL ] SELECT `a`.* FROM `cmf_user` `a` LEFT JOIN `cmf_project_user_cate` `b` ON `b`.`user_id`=`a`.`id` WHERE `a`.`id` <> 0 AND `a`.`is_expert` = 3 AND `user_type` = 2 AND `b`.`cate_one_id` IN (2,394,1) GROUP BY `a`.`id` LIMIT 3 [ RunTime:0.000962s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 0 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000590s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 2 ORDER BY `list_order` ASC [ RunTime:0.000571s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 28 ORDER BY `list_order` ASC [ RunTime:0.000512s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 29 ORDER BY `list_order` ASC [ RunTime:0.000515s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 30 ORDER BY `list_order` ASC [ RunTime:0.000527s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 31 ORDER BY `list_order` ASC [ RunTime:0.000551s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 32 ORDER BY `list_order` ASC [ RunTime:0.000498s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 33 ORDER BY `list_order` ASC [ RunTime:0.000499s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 34 ORDER BY `list_order` ASC [ RunTime:0.000499s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 35 ORDER BY `list_order` ASC [ RunTime:0.000467s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 1 ORDER BY `list_order` ASC [ RunTime:0.000478s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 19 ORDER BY `list_order` ASC [ RunTime:0.000490s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 21 ORDER BY `list_order` ASC [ RunTime:0.000518s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 22 ORDER BY `list_order` ASC [ RunTime:0.000519s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 23 ORDER BY `list_order` ASC [ RunTime:0.000531s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 24 ORDER BY `list_order` ASC [ RunTime:0.000545s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 25 ORDER BY `list_order` ASC [ RunTime:0.000499s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 26 ORDER BY `list_order` ASC [ RunTime:0.000496s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 27 ORDER BY `list_order` ASC [ RunTime:0.000470s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 3 ORDER BY `list_order` ASC [ RunTime:0.000469s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 36 ORDER BY `list_order` ASC [ RunTime:0.000507s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 37 ORDER BY `list_order` ASC [ RunTime:0.000494s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 38 ORDER BY `list_order` ASC [ RunTime:0.000487s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 39 ORDER BY `list_order` ASC [ RunTime:0.000467s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 4 ORDER BY `list_order` ASC [ RunTime:0.000476s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 388 ORDER BY `list_order` ASC [ RunTime:0.000488s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 389 ORDER BY `list_order` ASC [ RunTime:0.000487s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 390 ORDER BY `list_order` ASC [ RunTime:0.000491s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 419 ORDER BY `list_order` ASC [ RunTime:0.000477s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 5 ORDER BY `list_order` ASC [ RunTime:0.000486s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 420 ORDER BY `list_order` ASC [ RunTime:0.000495s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 421 ORDER BY `list_order` ASC [ RunTime:0.000512s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 422 ORDER BY `list_order` ASC [ RunTime:0.000494s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 6 ORDER BY `list_order` ASC [ RunTime:0.000497s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 76 ORDER BY `list_order` ASC [ RunTime:0.000509s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 77 ORDER BY `list_order` ASC [ RunTime:0.000529s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 78 ORDER BY `list_order` ASC [ RunTime:0.000510s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 79 ORDER BY `list_order` ASC [ RunTime:0.000521s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 80 ORDER BY `list_order` ASC [ RunTime:0.000502s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 81 ORDER BY `list_order` ASC [ RunTime:0.000495s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 82 ORDER BY `list_order` ASC [ RunTime:0.000497s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 444 ORDER BY `list_order` ASC [ RunTime:0.000494s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 83 ORDER BY `list_order` ASC [ RunTime:0.000476s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 393 ORDER BY `list_order` ASC [ RunTime:0.000493s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 522 ORDER BY `list_order` ASC [ RunTime:0.000488s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 523 ORDER BY `list_order` ASC [ RunTime:0.000507s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 524 ORDER BY `list_order` ASC [ RunTime:0.000519s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 525 ORDER BY `list_order` ASC [ RunTime:0.000503s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 394 ORDER BY `list_order` ASC [ RunTime:0.000500s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 561 ORDER BY `list_order` ASC [ RunTime:0.000494s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 562 ORDER BY `list_order` ASC [ RunTime:0.000500s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 563 ORDER BY `list_order` ASC [ RunTime:0.000485s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 395 ORDER BY `list_order` ASC [ RunTime:0.000485s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 579 ORDER BY `list_order` ASC [ RunTime:0.000485s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 580 ORDER BY `list_order` ASC [ RunTime:0.000485s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 581 ORDER BY `list_order` ASC [ RunTime:0.000469s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 582 ORDER BY `list_order` ASC [ RunTime:0.000485s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 396 ORDER BY `list_order` ASC [ RunTime:0.000485s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 589 ORDER BY `list_order` ASC [ RunTime:0.000484s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 590 ORDER BY `list_order` ASC [ RunTime:0.000499s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 591 ORDER BY `list_order` ASC [ RunTime:0.000495s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 592 ORDER BY `list_order` ASC [ RunTime:0.000474s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 397 ORDER BY `list_order` ASC [ RunTime:0.000492s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 601 ORDER BY `list_order` ASC [ RunTime:0.000492s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 602 ORDER BY `list_order` ASC [ RunTime:0.000482s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 603 ORDER BY `list_order` ASC [ RunTime:0.000469s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 604 ORDER BY `list_order` ASC [ RunTime:0.000471s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 616 ORDER BY `list_order` ASC [ RunTime:0.000481s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 398 ORDER BY `list_order` ASC [ RunTime:0.000483s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 617 ORDER BY `list_order` ASC [ RunTime:0.000503s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 618 ORDER BY `list_order` ASC [ RunTime:0.000511s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 399 ORDER BY `list_order` ASC [ RunTime:0.000504s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 632 ORDER BY `list_order` ASC [ RunTime:0.000503s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 633 ORDER BY `list_order` ASC [ RunTime:0.000493s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 0 AND `status` = 1 AND `is_expert` = 1 ORDER BY `list_order` ASC [ RunTime:0.000590s ]
