[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=1 and status=1 ) ORDER BY `list_order` [ RunTime:0.001809s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=5 and status=1 ) ORDER BY `list_order` [ RunTime:0.001786s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=6 and status=1 ) ORDER BY `list_order` [ RunTime:0.001767s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=7 and status=1 ) ORDER BY `list_order` [ RunTime:0.001779s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=8 and status=1 ) ORDER BY `list_order` [ RunTime:0.001726s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=9 and status=1 ) ORDER BY `list_order` [ RunTime:0.001757s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=10 and status=1 ) ORDER BY `list_order` [ RunTime:0.001742s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=19 and status=1 ) ORDER BY `list_order` [ RunTime:0.001816s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=20 and status=1 ) ORDER BY `list_order` [ RunTime:0.001754s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=21 and status=1 ) ORDER BY `list_order` [ RunTime:0.001992s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=22 and status=1 ) ORDER BY `list_order` [ RunTime:0.001719s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=1 and status=1 ) ORDER BY `list_order` [ RunTime:0.001643s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=5 and status=1 ) ORDER BY `list_order` [ RunTime:0.001917s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=6 and status=1 ) ORDER BY `list_order` [ RunTime:0.001598s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=7 and status=1 ) ORDER BY `list_order` [ RunTime:0.001623s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=8 and status=1 ) ORDER BY `list_order` [ RunTime:0.001615s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=9 and status=1 ) ORDER BY `list_order` [ RunTime:0.001597s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=10 and status=1 ) ORDER BY `list_order` [ RunTime:0.001620s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=19 and status=1 ) ORDER BY `list_order` [ RunTime:0.001555s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=20 and status=1 ) ORDER BY `list_order` [ RunTime:0.001578s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=21 and status=1 ) ORDER BY `list_order` [ RunTime:0.001652s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=22 and status=1 ) ORDER BY `list_order` [ RunTime:0.001725s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category_post` [ RunTime:0.002059s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_portal_category_post` `a` INNER JOIN `cmf_portal_post` `p` ON `a`.`post_id`=`p`.`id` WHERE `a`.`category_id` IN (5,6,7,8,9,10,19,20,21,22) AND ( p.post_status=1 and a.status=1 ) LIMIT 1 [ RunTime:0.002008s ]
[ SQL ] SELECT p.id as id,p.thumbnail as thumb,p.post_title as title FROM `cmf_portal_category_post` `a` INNER JOIN `cmf_portal_post` `p` ON `a`.`post_id`=`p`.`id` WHERE `a`.`category_id` IN (5,6,7,8,9,10,19,20,21,22) AND ( p.post_status=1 and a.status=1 ) ORDER BY `p`.`recommended` DESC,`p`.`published_time` DESC,`p`.`id` DESC LIMIT 36,6 [ RunTime:0.002027s ]
