[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=1 and status=1 ) ORDER BY `list_order` [ RunTime:0.001428s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=5 and status=1 ) ORDER BY `list_order` [ RunTime:0.001424s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=6 and status=1 ) ORDER BY `list_order` [ RunTime:0.001315s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=7 and status=1 ) ORDER BY `list_order` [ RunTime:0.001331s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=8 and status=1 ) ORDER BY `list_order` [ RunTime:0.001278s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=9 and status=1 ) ORDER BY `list_order` [ RunTime:0.001363s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=10 and status=1 ) ORDER BY `list_order` [ RunTime:0.001389s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=19 and status=1 ) ORDER BY `list_order` [ RunTime:0.001421s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=20 and status=1 ) ORDER BY `list_order` [ RunTime:0.001307s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=21 and status=1 ) ORDER BY `list_order` [ RunTime:0.001436s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=22 and status=1 ) ORDER BY `list_order` [ RunTime:0.001323s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=1 and status=1 ) ORDER BY `list_order` [ RunTime:0.001195s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=5 and status=1 ) ORDER BY `list_order` [ RunTime:0.001196s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=6 and status=1 ) ORDER BY `list_order` [ RunTime:0.001235s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=7 and status=1 ) ORDER BY `list_order` [ RunTime:0.001176s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=8 and status=1 ) ORDER BY `list_order` [ RunTime:0.001203s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=9 and status=1 ) ORDER BY `list_order` [ RunTime:0.001163s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=10 and status=1 ) ORDER BY `list_order` [ RunTime:0.001156s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=19 and status=1 ) ORDER BY `list_order` [ RunTime:0.001146s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=20 and status=1 ) ORDER BY `list_order` [ RunTime:0.001223s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=21 and status=1 ) ORDER BY `list_order` [ RunTime:0.001175s ]
[ SQL ] SELECT `id`,`name`,`path`,`parent_id` FROM `cmf_portal_category` WHERE ( parent_id=22 and status=1 ) ORDER BY `list_order` [ RunTime:0.001196s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category_post` [ RunTime:0.001779s ]
[ 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.001829s ]
[ 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.001642s ]
