[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=1 and status=1 ) ORDER BY `list_order` [ RunTime:0.002168s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=5 and status=1 ) ORDER BY `list_order` [ RunTime:0.002136s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=6 and status=1 ) ORDER BY `list_order` [ RunTime:0.002089s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=7 and status=1 ) ORDER BY `list_order` [ RunTime:0.002131s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=8 and status=1 ) ORDER BY `list_order` [ RunTime:0.002104s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=9 and status=1 ) ORDER BY `list_order` [ RunTime:0.002111s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=10 and status=1 ) ORDER BY `list_order` [ RunTime:0.002120s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=19 and status=1 ) ORDER BY `list_order` [ RunTime:0.002168s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=20 and status=1 ) ORDER BY `list_order` [ RunTime:0.002129s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=21 and status=1 ) ORDER BY `list_order` [ RunTime:0.002083s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=22 and status=1 ) ORDER BY `list_order` [ RunTime:0.002090s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=1 and status=1 ) ORDER BY `list_order` [ RunTime:0.001967s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=5 and status=1 ) ORDER BY `list_order` [ RunTime:0.001937s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=6 and status=1 ) ORDER BY `list_order` [ RunTime:0.001978s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=7 and status=1 ) ORDER BY `list_order` [ RunTime:0.002000s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=8 and status=1 ) ORDER BY `list_order` [ RunTime:0.001974s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=9 and status=1 ) ORDER BY `list_order` [ RunTime:0.001936s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=10 and status=1 ) ORDER BY `list_order` [ RunTime:0.002010s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=19 and status=1 ) ORDER BY `list_order` [ RunTime:0.001990s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=20 and status=1 ) ORDER BY `list_order` [ RunTime:0.001990s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=21 and status=1 ) ORDER BY `list_order` [ RunTime:0.001985s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=22 and status=1 ) ORDER BY `list_order` [ RunTime:0.001974s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category_post` [ RunTime:0.002844s ]
[ 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.002781s ]
[ 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 0,6 [ RunTime:0.002581s ]
