[ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.001041s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `parent_id` = 4 AND `delete_time` = 0 ORDER BY `list_order` ASC [ RunTime:0.000863s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `parent_id` = 388 AND `delete_time` = 0 ORDER BY `list_order` ASC [ RunTime:0.000807s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `parent_id` = 405 AND `delete_time` = 0 ORDER BY `list_order` ASC [ RunTime:0.000759s ]
[ SQL ] SHOW COLUMNS FROM `cmf_project_library` [ RunTime:0.003937s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_project_library` `a` LEFT JOIN `cmf_user` `b` ON `b`.`id`=`a`.`user_id` LEFT JOIN `cmf_portal_category` `c` ON `c`.`id`=`a`.`cate_one` WHERE `a`.`status` = 2 AND `cate_one` = 4 AND `cate_two` = 388 AND `cate_three` = 405 [ RunTime:0.002070s ]
[ SQL ] SELECT `a`.*,`b`.`user_nickname`,`c`.`name` FROM `cmf_project_library` `a` LEFT JOIN `cmf_user` `b` ON `b`.`id`=`a`.`user_id` LEFT JOIN `cmf_portal_category` `c` ON `c`.`id`=`a`.`cate_one` WHERE `a`.`status` = 2 AND `cate_one` = 4 AND `cate_two` = 388 AND `cate_three` = 405 ORDER BY `a`.`id` DESC LIMIT 0,10 [ RunTime:0.005500s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_project_library` `a` LEFT JOIN `cmf_user` `b` ON `b`.`id`=`a`.`user_id` LEFT JOIN `cmf_portal_category` `c` ON `c`.`id`=`a`.`cate_one` WHERE `a`.`status` = 2 AND `cate_one` = 4 AND `cate_two` = 388 AND `cate_three` = 405 ORDER BY `a`.`id` DESC [ RunTime:0.002174s ]
[ 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.000792s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 2 ORDER BY `list_order` ASC [ RunTime:0.000580s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 28 ORDER BY `list_order` ASC [ RunTime:0.000552s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 29 ORDER BY `list_order` ASC [ RunTime:0.000707s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 30 ORDER BY `list_order` ASC [ RunTime:0.000769s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 31 ORDER BY `list_order` ASC [ RunTime:0.000657s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 32 ORDER BY `list_order` ASC [ RunTime:0.000644s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 33 ORDER BY `list_order` ASC [ RunTime:0.000559s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 34 ORDER BY `list_order` ASC [ RunTime:0.001047s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 35 ORDER BY `list_order` ASC [ RunTime:0.000607s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 1 ORDER BY `list_order` ASC [ RunTime:0.000589s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 19 ORDER BY `list_order` ASC [ RunTime:0.000699s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 21 ORDER BY `list_order` ASC [ RunTime:0.000662s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 22 ORDER BY `list_order` ASC [ RunTime:0.000604s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 23 ORDER BY `list_order` ASC [ RunTime:0.000685s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 24 ORDER BY `list_order` ASC [ RunTime:0.000574s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 25 ORDER BY `list_order` ASC [ RunTime:0.000618s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 26 ORDER BY `list_order` ASC [ RunTime:0.000606s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 27 ORDER BY `list_order` ASC [ RunTime:0.000589s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 3 ORDER BY `list_order` ASC [ RunTime:0.000634s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 36 ORDER BY `list_order` ASC [ RunTime:0.000640s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 37 ORDER BY `list_order` ASC [ RunTime:0.000682s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 38 ORDER BY `list_order` ASC [ RunTime:0.000682s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 39 ORDER BY `list_order` ASC [ RunTime:0.000628s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 4 ORDER BY `list_order` ASC [ RunTime:0.000587s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 388 ORDER BY `list_order` ASC [ RunTime:0.000619s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 389 ORDER BY `list_order` ASC [ RunTime:0.000505s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 390 ORDER BY `list_order` ASC [ RunTime:0.000501s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 419 ORDER BY `list_order` ASC [ RunTime:0.000619s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 5 ORDER BY `list_order` ASC [ RunTime:0.000598s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 420 ORDER BY `list_order` ASC [ RunTime:0.000651s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 421 ORDER BY `list_order` ASC [ RunTime:0.000631s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 422 ORDER BY `list_order` ASC [ RunTime:0.000544s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 6 ORDER BY `list_order` ASC [ RunTime:0.000554s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 76 ORDER BY `list_order` ASC [ RunTime:0.000578s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 77 ORDER BY `list_order` ASC [ RunTime:0.000734s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 78 ORDER BY `list_order` ASC [ RunTime:0.000569s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 79 ORDER BY `list_order` ASC [ RunTime:0.000517s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 80 ORDER BY `list_order` ASC [ RunTime:0.000508s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 81 ORDER BY `list_order` ASC [ RunTime:0.000489s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 82 ORDER BY `list_order` ASC [ RunTime:0.000484s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 444 ORDER BY `list_order` ASC [ RunTime:0.000501s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 83 ORDER BY `list_order` ASC [ RunTime:0.000492s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 393 ORDER BY `list_order` ASC [ RunTime:0.000494s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 522 ORDER BY `list_order` ASC [ RunTime:0.000500s ]
[ 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.000663s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 525 ORDER BY `list_order` ASC [ RunTime:0.000676s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 394 ORDER BY `list_order` ASC [ RunTime:0.000477s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 561 ORDER BY `list_order` ASC [ RunTime:0.000559s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 562 ORDER BY `list_order` ASC [ RunTime:0.000762s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 563 ORDER BY `list_order` ASC [ RunTime:0.000690s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 395 ORDER BY `list_order` ASC [ RunTime:0.000641s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 579 ORDER BY `list_order` ASC [ RunTime:0.000563s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 580 ORDER BY `list_order` ASC [ RunTime:0.000694s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 581 ORDER BY `list_order` ASC [ RunTime:0.000667s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 582 ORDER BY `list_order` ASC [ RunTime:0.000621s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 396 ORDER BY `list_order` ASC [ RunTime:0.000542s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 589 ORDER BY `list_order` ASC [ RunTime:0.000507s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 590 ORDER BY `list_order` ASC [ RunTime:0.000596s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 591 ORDER BY `list_order` ASC [ RunTime:0.000655s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 592 ORDER BY `list_order` ASC [ RunTime:0.000657s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 397 ORDER BY `list_order` ASC [ RunTime:0.000770s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 601 ORDER BY `list_order` ASC [ RunTime:0.000673s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 602 ORDER BY `list_order` ASC [ RunTime:0.000605s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 603 ORDER BY `list_order` ASC [ RunTime:0.000690s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 604 ORDER BY `list_order` ASC [ RunTime:0.000549s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 616 ORDER BY `list_order` ASC [ RunTime:0.000612s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 398 ORDER BY `list_order` ASC [ RunTime:0.000575s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 617 ORDER BY `list_order` ASC [ RunTime:0.000609s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 618 ORDER BY `list_order` ASC [ RunTime:0.000694s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 399 ORDER BY `list_order` ASC [ RunTime:0.000702s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 632 ORDER BY `list_order` ASC [ RunTime:0.000562s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 633 ORDER BY `list_order` ASC [ RunTime:0.000573s ]
[ 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.000537s ]
[ 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.000827s ]