[ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.000725s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `parent_id` = 0 AND `is_expert` = 1 AND `delete_time` = 0 ORDER BY `list_order` ASC [ RunTime:0.000584s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `parent_id` = 2 AND `is_expert` = 1 AND `delete_time` = 0 ORDER BY `list_order` ASC [ RunTime:0.000530s ]
[ SQL ] SHOW COLUMNS FROM `cmf_user` [ RunTime:0.000882s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count FROM `cmf_user` `a` LEFT JOIN `cmf_project_question` `q` ON `q`.`accept_user_id`=a.id and q.status=2 LEFT JOIN `cmf_project_user_cate` `b` ON `b`.`user_id`=`a`.`id` WHERE `is_expert` = 3 AND `cate_one_id` = 2 AND `cate_two_id` = 33 GROUP BY `a`.`id` ) `_group_count_` [ RunTime:0.000371s ]
[ SQL ] SELECT a.*,count( distinct q.id) as solve FROM `cmf_user` `a` LEFT JOIN `cmf_project_question` `q` ON `q`.`accept_user_id`=a.id and q.status=2 LEFT JOIN `cmf_project_user_cate` `b` ON `b`.`user_id`=`a`.`id` WHERE `is_expert` = 3 AND `cate_one_id` = 2 AND `cate_two_id` = 33 GROUP BY `a`.`id` ORDER BY `solve` DESC LIMIT 0,20 [ RunTime:0.000962s ]
[ SQL ] SHOW COLUMNS FROM `cmf_project_question` [ RunTime:0.000652s ]
[ SQL ] SELECT `a`.*,`b`.`name` FROM `cmf_project_question` `a` LEFT JOIN `cmf_portal_category` `b` ON `b`.`id`=`a`.`cate_id` ORDER BY `id` DESC LIMIT 8 [ RunTime:0.000264s ]
[ SQL ] SELECT `a`.*,`b`.`name` FROM `cmf_project_question` `a` LEFT JOIN `cmf_portal_category` `b` ON `b`.`id`=`a`.`cate_id` ORDER BY `id` DESC LIMIT 4 [ RunTime:0.000192s ]
[ 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.000526s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 2 ORDER BY `list_order` ASC [ RunTime:0.000470s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 28 ORDER BY `list_order` ASC [ RunTime:0.000411s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 29 ORDER BY `list_order` ASC [ RunTime:0.000412s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 30 ORDER BY `list_order` ASC [ RunTime:0.000447s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 31 ORDER BY `list_order` ASC [ RunTime:0.000464s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 32 ORDER BY `list_order` ASC [ RunTime:0.000421s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 33 ORDER BY `list_order` ASC [ RunTime:0.000420s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 34 ORDER BY `list_order` ASC [ RunTime:0.000434s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 35 ORDER BY `list_order` ASC [ RunTime:0.000398s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 1 ORDER BY `list_order` ASC [ RunTime:0.000420s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 19 ORDER BY `list_order` ASC [ RunTime:0.000445s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 21 ORDER BY `list_order` ASC [ RunTime:0.000570s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 22 ORDER BY `list_order` ASC [ RunTime:0.000532s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 23 ORDER BY `list_order` ASC [ RunTime:0.001177s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 24 ORDER BY `list_order` ASC [ RunTime:0.000642s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 25 ORDER BY `list_order` ASC [ RunTime:0.000569s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 26 ORDER BY `list_order` ASC [ RunTime:0.000745s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 27 ORDER BY `list_order` ASC [ RunTime:0.000706s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 3 ORDER BY `list_order` ASC [ RunTime:0.000541s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 36 ORDER BY `list_order` ASC [ RunTime:0.000649s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 37 ORDER BY `list_order` ASC [ RunTime:0.000715s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 38 ORDER BY `list_order` ASC [ RunTime:0.000563s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 39 ORDER BY `list_order` ASC [ RunTime:0.000597s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 4 ORDER BY `list_order` ASC [ RunTime:0.000512s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 388 ORDER BY `list_order` ASC [ RunTime:0.000547s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 389 ORDER BY `list_order` ASC [ RunTime:0.000459s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 390 ORDER BY `list_order` ASC [ RunTime:0.000414s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 419 ORDER BY `list_order` ASC [ RunTime:0.000621s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 5 ORDER BY `list_order` ASC [ RunTime:0.000419s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 420 ORDER BY `list_order` ASC [ RunTime:0.000403s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 421 ORDER BY `list_order` ASC [ RunTime:0.000448s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 422 ORDER BY `list_order` ASC [ RunTime:0.000439s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 6 ORDER BY `list_order` ASC [ RunTime:0.000455s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 76 ORDER BY `list_order` ASC [ RunTime:0.000439s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 77 ORDER BY `list_order` ASC [ RunTime:0.000457s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 78 ORDER BY `list_order` ASC [ RunTime:0.000410s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 79 ORDER BY `list_order` ASC [ RunTime:0.000423s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 80 ORDER BY `list_order` ASC [ RunTime:0.000435s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 81 ORDER BY `list_order` ASC [ RunTime:0.000400s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 82 ORDER BY `list_order` ASC [ RunTime:0.000411s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 444 ORDER BY `list_order` ASC [ RunTime:0.000422s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 83 ORDER BY `list_order` ASC [ RunTime:0.000408s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 393 ORDER BY `list_order` ASC [ RunTime:0.000387s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 522 ORDER BY `list_order` ASC [ RunTime:0.000403s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 523 ORDER BY `list_order` ASC [ RunTime:0.000419s ]
[ 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.000436s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 394 ORDER BY `list_order` ASC [ RunTime:0.000523s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 561 ORDER BY `list_order` ASC [ RunTime:0.000507s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 562 ORDER BY `list_order` ASC [ RunTime:0.000510s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 563 ORDER BY `list_order` ASC [ RunTime:0.000490s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 395 ORDER BY `list_order` ASC [ RunTime:0.000496s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 579 ORDER BY `list_order` ASC [ RunTime:0.000524s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 580 ORDER BY `list_order` ASC [ RunTime:0.000479s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 581 ORDER BY `list_order` ASC [ RunTime:0.000458s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 582 ORDER BY `list_order` ASC [ RunTime:0.000451s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 396 ORDER BY `list_order` ASC [ RunTime:0.000481s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 589 ORDER BY `list_order` ASC [ RunTime:0.000509s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 590 ORDER BY `list_order` ASC [ RunTime:0.000503s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 591 ORDER BY `list_order` ASC [ RunTime:0.000493s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 592 ORDER BY `list_order` ASC [ RunTime:0.000483s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 397 ORDER BY `list_order` ASC [ RunTime:0.000482s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 601 ORDER BY `list_order` ASC [ RunTime:0.000481s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 602 ORDER BY `list_order` ASC [ RunTime:0.000464s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 603 ORDER BY `list_order` ASC [ RunTime:0.000463s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 604 ORDER BY `list_order` ASC [ RunTime:0.000456s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 616 ORDER BY `list_order` ASC [ RunTime:0.000468s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 398 ORDER BY `list_order` ASC [ RunTime:0.000485s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 617 ORDER BY `list_order` ASC [ RunTime:0.000499s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 618 ORDER BY `list_order` ASC [ RunTime:0.000502s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 399 ORDER BY `list_order` ASC [ RunTime:0.000495s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 632 ORDER BY `list_order` ASC [ RunTime:0.000481s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 633 ORDER BY `list_order` ASC [ RunTime:0.000484s ]
[ 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.000594s ]