[ 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` = 319 [ RunTime:0.000300s ]
[ 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` = 319 LIMIT 0,3 [ RunTime:0.000315s ]
[ 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,6,3) GROUP BY `a`.`id` LIMIT 3 [ RunTime:0.001042s ]
[ 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.000555s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 2 ORDER BY `list_order` ASC [ RunTime:0.000429s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 28 ORDER BY `list_order` ASC [ RunTime:0.000447s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 29 ORDER BY `list_order` ASC [ RunTime:0.000429s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 30 ORDER BY `list_order` ASC [ RunTime:0.000469s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 31 ORDER BY `list_order` ASC [ RunTime:0.000458s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 32 ORDER BY `list_order` ASC [ RunTime:0.000422s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 33 ORDER BY `list_order` ASC [ RunTime:0.000450s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 34 ORDER BY `list_order` ASC [ RunTime:0.000468s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 35 ORDER BY `list_order` ASC [ RunTime:0.000419s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 1 ORDER BY `list_order` ASC [ RunTime:0.000459s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 19 ORDER BY `list_order` ASC [ RunTime:0.000429s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 21 ORDER BY `list_order` ASC [ RunTime:0.000429s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 22 ORDER BY `list_order` ASC [ RunTime:0.000422s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 23 ORDER BY `list_order` ASC [ RunTime:0.000459s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 24 ORDER BY `list_order` ASC [ RunTime:0.000452s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 25 ORDER BY `list_order` ASC [ RunTime:0.000432s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 26 ORDER BY `list_order` ASC [ RunTime:0.000867s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 27 ORDER BY `list_order` ASC [ RunTime:0.000421s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 3 ORDER BY `list_order` ASC [ RunTime:0.000411s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 36 ORDER BY `list_order` ASC [ RunTime:0.000434s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 37 ORDER BY `list_order` ASC [ RunTime:0.000433s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 38 ORDER BY `list_order` ASC [ RunTime:0.000456s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 39 ORDER BY `list_order` ASC [ RunTime:0.000428s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 4 ORDER BY `list_order` ASC [ RunTime:0.000416s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 388 ORDER BY `list_order` ASC [ RunTime:0.000413s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 389 ORDER BY `list_order` ASC [ RunTime:0.000423s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 390 ORDER BY `list_order` ASC [ RunTime:0.000422s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 419 ORDER BY `list_order` ASC [ RunTime:0.000558s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 5 ORDER BY `list_order` ASC [ RunTime:0.000507s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 420 ORDER BY `list_order` ASC [ RunTime:0.000505s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 421 ORDER BY `list_order` ASC [ RunTime:0.000550s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 422 ORDER BY `list_order` ASC [ RunTime:0.000508s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 6 ORDER BY `list_order` ASC [ RunTime:0.000523s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 76 ORDER BY `list_order` ASC [ RunTime:0.000446s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 77 ORDER BY `list_order` ASC [ RunTime:0.000437s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 78 ORDER BY `list_order` ASC [ RunTime:0.000430s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 79 ORDER BY `list_order` ASC [ RunTime:0.000447s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 80 ORDER BY `list_order` ASC [ RunTime:0.000467s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 81 ORDER BY `list_order` ASC [ RunTime:0.000438s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 82 ORDER BY `list_order` ASC [ RunTime:0.000417s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 444 ORDER BY `list_order` ASC [ RunTime:0.000417s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 83 ORDER BY `list_order` ASC [ RunTime:0.000415s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 393 ORDER BY `list_order` ASC [ RunTime:0.000423s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 522 ORDER BY `list_order` ASC [ RunTime:0.000427s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 523 ORDER BY `list_order` ASC [ RunTime:0.000427s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 524 ORDER BY `list_order` ASC [ RunTime:0.000421s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 525 ORDER BY `list_order` ASC [ RunTime:0.000412s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 394 ORDER BY `list_order` ASC [ RunTime:0.000422s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 561 ORDER BY `list_order` ASC [ RunTime:0.000414s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 562 ORDER BY `list_order` ASC [ RunTime:0.000424s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 563 ORDER BY `list_order` ASC [ RunTime:0.000414s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 395 ORDER BY `list_order` ASC [ RunTime:0.000413s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 579 ORDER BY `list_order` ASC [ RunTime:0.000423s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 580 ORDER BY `list_order` ASC [ RunTime:0.000411s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 581 ORDER BY `list_order` ASC [ RunTime:0.000400s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 582 ORDER BY `list_order` ASC [ RunTime:0.000424s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 396 ORDER BY `list_order` ASC [ RunTime:0.000423s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 589 ORDER BY `list_order` ASC [ RunTime:0.000421s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 590 ORDER BY `list_order` ASC [ RunTime:0.000421s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 591 ORDER BY `list_order` ASC [ RunTime:0.000408s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 592 ORDER BY `list_order` ASC [ RunTime:0.000407s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 397 ORDER BY `list_order` ASC [ RunTime:0.000413s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 601 ORDER BY `list_order` ASC [ RunTime:0.000472s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 602 ORDER BY `list_order` ASC [ RunTime:0.000438s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 603 ORDER BY `list_order` ASC [ RunTime:0.000408s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 604 ORDER BY `list_order` ASC [ RunTime:0.000416s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 616 ORDER BY `list_order` ASC [ RunTime:0.000420s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 398 ORDER BY `list_order` ASC [ RunTime:0.000404s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 617 ORDER BY `list_order` ASC [ RunTime:0.000436s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 618 ORDER BY `list_order` ASC [ RunTime:0.000436s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 399 ORDER BY `list_order` ASC [ RunTime:0.000429s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 632 ORDER BY `list_order` ASC [ RunTime:0.000422s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 633 ORDER BY `list_order` ASC [ RunTime:0.000422s ]
[ 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.000589s ]
