SHOW FULL COLUMNS FROM `cmf_plugin` [ RunTime:0.001340s ]
SELECT `config` FROM `cmf_plugin` WHERE `name` = 'SpiderLog' LIMIT 1 [ RunTime:0.000337s ]
SHOW FULL COLUMNS FROM `cmf_portal_post` [ RunTime:0.001146s ]
SELECT * FROM `cmf_portal_post` WHERE `post_type` = 2 AND `post_status` = 1 AND `delete_time` = 0 AND `id` = 2 AND ( `published_time` > 0 AND `published_time` < 1628347117 ) LIMIT 1 [ RunTime:0.000497s ]
SHOW FULL COLUMNS FROM `cmf_theme_file` [ RunTime:0.001393s ]
SELECT * FROM `cmf_theme_file` WHERE `theme` = 'creatink' AND `file` = 'portal/article' LIMIT 1 [ RunTime:0.000329s ]
SELECT `more` FROM `cmf_theme_file` WHERE `theme` = 'creatink' AND ( `is_public` = 1 OR `file` = 'portal/contact' ) [ RunTime:0.000518s ]
SHOW FULL COLUMNS FROM `cmf_option` [ RunTime:0.001504s ]
SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'storage' LIMIT 1 [ RunTime:0.000346s ]
SHOW FULL COLUMNS FROM `cmf_nav` [ RunTime:0.001230s ]
SELECT `id` FROM `cmf_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.000368s ]
SHOW FULL COLUMNS FROM `cmf_nav_menu` [ RunTime:0.001190s ]
SELECT * FROM `cmf_nav_menu` WHERE `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000374s ]
SELECT post.*,min(category_post.category_id) as category_id,min(category_post.list_order) as list_order FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = '1' AND `post`.`post_type` = '1' AND `post`.`delete_time` = '0' AND ( `post`.`recommended` = '1' ) AND ( `category_post`.`category_id` = '3' ) AND ( `post`.`published_time` > '0' AND `post`.`published_time` < '1628347117' ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 4 [ RunTime:0.001320s ]
SHOW FULL COLUMNS FROM `cmf_portal_channel_bind` [ RunTime:0.001167s ]
SELECT `cf`.* FROM `cmf_portal_channel_bind` `cb` INNER JOIN `cmf_portal_channel_field` `cf` ON `cf`.`id`=`cb`.`field_id` WHERE `cb`.`typeid` = '3' ORDER BY `cf`.`list_order` [ RunTime:0.000857s ]
SHOW FULL COLUMNS FROM `cmf_portal_channel_post` [ RunTime:0.001006s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 35 AND `field_id` = 1 LIMIT 1 [ RunTime:0.000470s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 35 AND `field_id` = 2 LIMIT 1 [ RunTime:0.000427s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 35 AND `field_id` = 3 LIMIT 1 [ RunTime:0.000350s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 35 AND `field_id` = 4 LIMIT 1 [ RunTime:0.000305s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 35 AND `field_id` = 5 LIMIT 1 [ RunTime:0.000284s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 35 AND `field_id` = 6 LIMIT 1 [ RunTime:0.000258s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 35 AND `field_id` = 7 LIMIT 1 [ RunTime:0.000270s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 35 AND `field_id` = 20 LIMIT 1 [ RunTime:0.000307s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 35 AND `field_id` = 21 LIMIT 1 [ RunTime:0.000308s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 35 AND `field_id` = 22 LIMIT 1 [ RunTime:0.000282s ]
SELECT `cf`.* FROM `cmf_portal_channel_bind` `cb` INNER JOIN `cmf_portal_channel_field` `cf` ON `cf`.`id`=`cb`.`field_id` WHERE `cb`.`typeid` = '3' ORDER BY `cf`.`list_order` [ RunTime:0.001144s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 34 AND `field_id` = 1 LIMIT 1 [ RunTime:0.000417s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 34 AND `field_id` = 2 LIMIT 1 [ RunTime:0.000377s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 34 AND `field_id` = 3 LIMIT 1 [ RunTime:0.000432s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 34 AND `field_id` = 4 LIMIT 1 [ RunTime:0.000417s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 34 AND `field_id` = 5 LIMIT 1 [ RunTime:0.000395s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 34 AND `field_id` = 6 LIMIT 1 [ RunTime:0.000364s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 34 AND `field_id` = 7 LIMIT 1 [ RunTime:0.000363s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 34 AND `field_id` = 20 LIMIT 1 [ RunTime:0.000349s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 34 AND `field_id` = 21 LIMIT 1 [ RunTime:0.000374s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 34 AND `field_id` = 22 LIMIT 1 [ RunTime:0.000368s ]
SELECT `cf`.* FROM `cmf_portal_channel_bind` `cb` INNER JOIN `cmf_portal_channel_field` `cf` ON `cf`.`id`=`cb`.`field_id` WHERE `cb`.`typeid` = '3' ORDER BY `cf`.`list_order` [ RunTime:0.001336s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 33 AND `field_id` = 1 LIMIT 1 [ RunTime:0.000642s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 33 AND `field_id` = 2 LIMIT 1 [ RunTime:0.000425s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 33 AND `field_id` = 3 LIMIT 1 [ RunTime:0.000395s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 33 AND `field_id` = 4 LIMIT 1 [ RunTime:0.000374s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 33 AND `field_id` = 5 LIMIT 1 [ RunTime:0.000344s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 33 AND `field_id` = 6 LIMIT 1 [ RunTime:0.000371s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 33 AND `field_id` = 7 LIMIT 1 [ RunTime:0.000325s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 33 AND `field_id` = 20 LIMIT 1 [ RunTime:0.000310s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 33 AND `field_id` = 21 LIMIT 1 [ RunTime:0.000344s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 33 AND `field_id` = 22 LIMIT 1 [ RunTime:0.000360s ]
SELECT `cf`.* FROM `cmf_portal_channel_bind` `cb` INNER JOIN `cmf_portal_channel_field` `cf` ON `cf`.`id`=`cb`.`field_id` WHERE `cb`.`typeid` = '3' ORDER BY `cf`.`list_order` [ RunTime:0.001347s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 32 AND `field_id` = 1 LIMIT 1 [ RunTime:0.000552s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 32 AND `field_id` = 2 LIMIT 1 [ RunTime:0.000496s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 32 AND `field_id` = 3 LIMIT 1 [ RunTime:0.000446s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 32 AND `field_id` = 4 LIMIT 1 [ RunTime:0.000410s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 32 AND `field_id` = 5 LIMIT 1 [ RunTime:0.000382s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 32 AND `field_id` = 6 LIMIT 1 [ RunTime:0.000344s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 32 AND `field_id` = 7 LIMIT 1 [ RunTime:0.000377s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 32 AND `field_id` = 20 LIMIT 1 [ RunTime:0.000375s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 32 AND `field_id` = 21 LIMIT 1 [ RunTime:0.000409s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 32 AND `field_id` = 22 LIMIT 1 [ RunTime:0.000363s ]
SELECT post.*,min(category_post.category_id) as category_id,min(category_post.list_order) as list_order FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = '1' AND `post`.`post_type` = '1' AND `post`.`delete_time` = '0' AND ( `post`.`recommended` = '1' ) AND ( `category_post`.`category_id` = '2' ) AND ( `post`.`published_time` > '0' AND `post`.`published_time` < '1628347117' ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 4 [ RunTime:0.001593s ]
SELECT `cf`.* FROM `cmf_portal_channel_bind` `cb` INNER JOIN `cmf_portal_channel_field` `cf` ON `cf`.`id`=`cb`.`field_id` WHERE `cb`.`typeid` = '2' ORDER BY `cf`.`list_order` [ RunTime:0.000931s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 39 AND `field_id` = 1 LIMIT 1 [ RunTime:0.000511s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 39 AND `field_id` = 2 LIMIT 1 [ RunTime:0.000430s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 39 AND `field_id` = 3 LIMIT 1 [ RunTime:0.000381s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 39 AND `field_id` = 4 LIMIT 1 [ RunTime:0.000349s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 39 AND `field_id` = 5 LIMIT 1 [ RunTime:0.000331s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 39 AND `field_id` = 6 LIMIT 1 [ RunTime:0.000358s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 39 AND `field_id` = 7 LIMIT 1 [ RunTime:0.000307s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 39 AND `field_id` = 20 LIMIT 1 [ RunTime:0.000281s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 39 AND `field_id` = 21 LIMIT 1 [ RunTime:0.000303s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 39 AND `field_id` = 22 LIMIT 1 [ RunTime:0.000304s ]
SELECT `cf`.* FROM `cmf_portal_channel_bind` `cb` INNER JOIN `cmf_portal_channel_field` `cf` ON `cf`.`id`=`cb`.`field_id` WHERE `cb`.`typeid` = '2' ORDER BY `cf`.`list_order` [ RunTime:0.001073s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 38 AND `field_id` = 1 LIMIT 1 [ RunTime:0.000454s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 38 AND `field_id` = 2 LIMIT 1 [ RunTime:0.000413s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 38 AND `field_id` = 3 LIMIT 1 [ RunTime:0.000384s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 38 AND `field_id` = 4 LIMIT 1 [ RunTime:0.000312s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 38 AND `field_id` = 5 LIMIT 1 [ RunTime:0.000310s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 38 AND `field_id` = 6 LIMIT 1 [ RunTime:0.000310s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 38 AND `field_id` = 7 LIMIT 1 [ RunTime:0.000306s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 38 AND `field_id` = 20 LIMIT 1 [ RunTime:0.000353s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 38 AND `field_id` = 21 LIMIT 1 [ RunTime:0.000335s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 38 AND `field_id` = 22 LIMIT 1 [ RunTime:0.000292s ]
SELECT `cf`.* FROM `cmf_portal_channel_bind` `cb` INNER JOIN `cmf_portal_channel_field` `cf` ON `cf`.`id`=`cb`.`field_id` WHERE `cb`.`typeid` = '2' ORDER BY `cf`.`list_order` [ RunTime:0.001154s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 37 AND `field_id` = 1 LIMIT 1 [ RunTime:0.000473s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 37 AND `field_id` = 2 LIMIT 1 [ RunTime:0.000345s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 37 AND `field_id` = 3 LIMIT 1 [ RunTime:0.000326s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 37 AND `field_id` = 4 LIMIT 1 [ RunTime:0.000333s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 37 AND `field_id` = 5 LIMIT 1 [ RunTime:0.000292s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 37 AND `field_id` = 6 LIMIT 1 [ RunTime:0.000314s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 37 AND `field_id` = 7 LIMIT 1 [ RunTime:0.000274s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 37 AND `field_id` = 20 LIMIT 1 [ RunTime:0.000301s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 37 AND `field_id` = 21 LIMIT 1 [ RunTime:0.000307s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 37 AND `field_id` = 22 LIMIT 1 [ RunTime:0.000360s ]
SELECT `cf`.* FROM `cmf_portal_channel_bind` `cb` INNER JOIN `cmf_portal_channel_field` `cf` ON `cf`.`id`=`cb`.`field_id` WHERE `cb`.`typeid` = '2' ORDER BY `cf`.`list_order` [ RunTime:0.001134s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 36 AND `field_id` = 1 LIMIT 1 [ RunTime:0.000435s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 36 AND `field_id` = 2 LIMIT 1 [ RunTime:0.000312s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 36 AND `field_id` = 3 LIMIT 1 [ RunTime:0.000337s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 36 AND `field_id` = 4 LIMIT 1 [ RunTime:0.000313s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 36 AND `field_id` = 5 LIMIT 1 [ RunTime:0.000292s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 36 AND `field_id` = 6 LIMIT 1 [ RunTime:0.000629s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 36 AND `field_id` = 7 LIMIT 1 [ RunTime:0.000362s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 36 AND `field_id` = 20 LIMIT 1 [ RunTime:0.000418s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 36 AND `field_id` = 21 LIMIT 1 [ RunTime:0.000370s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 36 AND `field_id` = 22 LIMIT 1 [ RunTime:0.000324s ]
SELECT post.*,min(category_post.category_id) as category_id,min(category_post.list_order) as list_order FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = '1' AND `post`.`post_type` = '1' AND `post`.`delete_time` = '0' AND ( `post`.`recommended` = '1' ) AND ( `category_post`.`category_id` = '4' ) AND ( `post`.`published_time` > '0' AND `post`.`published_time` < '1628347117' ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 4 [ RunTime:0.001521s ]
SELECT `cf`.* FROM `cmf_portal_channel_bind` `cb` INNER JOIN `cmf_portal_channel_field` `cf` ON `cf`.`id`=`cb`.`field_id` WHERE `cb`.`typeid` = '4' ORDER BY `cf`.`list_order` [ RunTime:0.000922s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 49 AND `field_id` = 1 LIMIT 1 [ RunTime:0.000574s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 49 AND `field_id` = 2 LIMIT 1 [ RunTime:0.000639s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 49 AND `field_id` = 3 LIMIT 1 [ RunTime:0.000571s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 49 AND `field_id` = 4 LIMIT 1 [ RunTime:0.000504s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 49 AND `field_id` = 5 LIMIT 1 [ RunTime:0.000557s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 49 AND `field_id` = 6 LIMIT 1 [ RunTime:0.000488s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 49 AND `field_id` = 7 LIMIT 1 [ RunTime:0.000469s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 49 AND `field_id` = 20 LIMIT 1 [ RunTime:0.000523s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 49 AND `field_id` = 21 LIMIT 1 [ RunTime:0.000491s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 49 AND `field_id` = 22 LIMIT 1 [ RunTime:0.000526s ]
SELECT `cf`.* FROM `cmf_portal_channel_bind` `cb` INNER JOIN `cmf_portal_channel_field` `cf` ON `cf`.`id`=`cb`.`field_id` WHERE `cb`.`typeid` = '4' ORDER BY `cf`.`list_order` [ RunTime:0.001559s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 48 AND `field_id` = 1 LIMIT 1 [ RunTime:0.000633s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 48 AND `field_id` = 2 LIMIT 1 [ RunTime:0.000465s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 48 AND `field_id` = 3 LIMIT 1 [ RunTime:0.000442s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 48 AND `field_id` = 4 LIMIT 1 [ RunTime:0.000410s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 48 AND `field_id` = 5 LIMIT 1 [ RunTime:0.000453s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 48 AND `field_id` = 6 LIMIT 1 [ RunTime:0.000375s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 48 AND `field_id` = 7 LIMIT 1 [ RunTime:0.000409s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 48 AND `field_id` = 20 LIMIT 1 [ RunTime:0.000449s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 48 AND `field_id` = 21 LIMIT 1 [ RunTime:0.000468s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 48 AND `field_id` = 22 LIMIT 1 [ RunTime:0.000414s ]
SELECT `cf`.* FROM `cmf_portal_channel_bind` `cb` INNER JOIN `cmf_portal_channel_field` `cf` ON `cf`.`id`=`cb`.`field_id` WHERE `cb`.`typeid` = '4' ORDER BY `cf`.`list_order` [ RunTime:0.001380s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 47 AND `field_id` = 1 LIMIT 1 [ RunTime:0.000667s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 47 AND `field_id` = 2 LIMIT 1 [ RunTime:0.000524s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 47 AND `field_id` = 3 LIMIT 1 [ RunTime:0.000440s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 47 AND `field_id` = 4 LIMIT 1 [ RunTime:0.000415s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 47 AND `field_id` = 5 LIMIT 1 [ RunTime:0.000399s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 47 AND `field_id` = 6 LIMIT 1 [ RunTime:0.000360s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 47 AND `field_id` = 7 LIMIT 1 [ RunTime:0.000410s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 47 AND `field_id` = 20 LIMIT 1 [ RunTime:0.000382s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 47 AND `field_id` = 21 LIMIT 1 [ RunTime:0.000500s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 47 AND `field_id` = 22 LIMIT 1 [ RunTime:0.000497s ]
SELECT `cf`.* FROM `cmf_portal_channel_bind` `cb` INNER JOIN `cmf_portal_channel_field` `cf` ON `cf`.`id`=`cb`.`field_id` WHERE `cb`.`typeid` = '4' ORDER BY `cf`.`list_order` [ RunTime:0.001479s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 46 AND `field_id` = 1 LIMIT 1 [ RunTime:0.000675s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 46 AND `field_id` = 2 LIMIT 1 [ RunTime:0.000456s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 46 AND `field_id` = 3 LIMIT 1 [ RunTime:0.000537s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 46 AND `field_id` = 4 LIMIT 1 [ RunTime:0.000573s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 46 AND `field_id` = 5 LIMIT 1 [ RunTime:0.000490s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 46 AND `field_id` = 6 LIMIT 1 [ RunTime:0.000439s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 46 AND `field_id` = 7 LIMIT 1 [ RunTime:0.000434s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 46 AND `field_id` = 20 LIMIT 1 [ RunTime:0.000459s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 46 AND `field_id` = 21 LIMIT 1 [ RunTime:0.000375s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 46 AND `field_id` = 22 LIMIT 1 [ RunTime:0.000430s ]
SELECT post.*,min(category_post.category_id) as category_id,min(category_post.list_order) as list_order FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = '1' AND `post`.`post_type` = '1' AND `post`.`delete_time` = '0' AND ( `post`.`recommended` = '1' ) AND ( `category_post`.`category_id` = '5' ) AND ( `post`.`published_time` > '0' AND `post`.`published_time` < '1628347117' ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 4 [ RunTime:0.001345s ]
SELECT `cf`.* FROM `cmf_portal_channel_bind` `cb` INNER JOIN `cmf_portal_channel_field` `cf` ON `cf`.`id`=`cb`.`field_id` WHERE `cb`.`typeid` = '5' ORDER BY `cf`.`list_order` [ RunTime:0.001038s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 51 AND `field_id` = 1 LIMIT 1 [ RunTime:0.000636s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 51 AND `field_id` = 2 LIMIT 1 [ RunTime:0.000469s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 51 AND `field_id` = 3 LIMIT 1 [ RunTime:0.000554s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 51 AND `field_id` = 4 LIMIT 1 [ RunTime:0.000474s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 51 AND `field_id` = 5 LIMIT 1 [ RunTime:0.000410s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 51 AND `field_id` = 6 LIMIT 1 [ RunTime:0.000528s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 51 AND `field_id` = 7 LIMIT 1 [ RunTime:0.000408s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 51 AND `field_id` = 20 LIMIT 1 [ RunTime:0.000401s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 51 AND `field_id` = 21 LIMIT 1 [ RunTime:0.000369s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 51 AND `field_id` = 22 LIMIT 1 [ RunTime:0.000372s ]
SELECT `cf`.* FROM `cmf_portal_channel_bind` `cb` INNER JOIN `cmf_portal_channel_field` `cf` ON `cf`.`id`=`cb`.`field_id` WHERE `cb`.`typeid` = '5' ORDER BY `cf`.`list_order` [ RunTime:0.001169s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 50 AND `field_id` = 1 LIMIT 1 [ RunTime:0.000732s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 50 AND `field_id` = 2 LIMIT 1 [ RunTime:0.000634s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 50 AND `field_id` = 3 LIMIT 1 [ RunTime:0.000558s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 50 AND `field_id` = 4 LIMIT 1 [ RunTime:0.000467s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 50 AND `field_id` = 5 LIMIT 1 [ RunTime:0.000553s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 50 AND `field_id` = 6 LIMIT 1 [ RunTime:0.000852s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 50 AND `field_id` = 7 LIMIT 1 [ RunTime:0.000526s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 50 AND `field_id` = 20 LIMIT 1 [ RunTime:0.000433s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 50 AND `field_id` = 21 LIMIT 1 [ RunTime:0.000422s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 50 AND `field_id` = 22 LIMIT 1 [ RunTime:0.000494s ]
SHOW FULL COLUMNS FROM `cmf_portal_category` [ RunTime:0.001417s ]
SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `id` IN (2,3,4,5) [ RunTime:0.000406s ]
SELECT post.*,min(category_post.category_id) as category_id,min(category_post.list_order) as list_order FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = '1' AND `post`.`post_type` = '1' AND `post`.`delete_time` = '0' AND ( `post`.`recommended` = '1' ) AND ( `category_post`.`category_id` = '2' ) AND ( `post`.`published_time` > '0' AND `post`.`published_time` < '1628347117' ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 6 [ RunTime:0.001125s ]
SELECT `cf`.* FROM `cmf_portal_channel_bind` `cb` INNER JOIN `cmf_portal_channel_field` `cf` ON `cf`.`id`=`cb`.`field_id` WHERE `cb`.`typeid` = '2' ORDER BY `cf`.`list_order` [ RunTime:0.001915s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 39 AND `field_id` = 1 LIMIT 1 [ RunTime:0.000538s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 39 AND `field_id` = 2 LIMIT 1 [ RunTime:0.000531s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 39 AND `field_id` = 3 LIMIT 1 [ RunTime:0.000401s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 39 AND `field_id` = 4 LIMIT 1 [ RunTime:0.000471s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 39 AND `field_id` = 5 LIMIT 1 [ RunTime:0.000449s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 39 AND `field_id` = 6 LIMIT 1 [ RunTime:0.000412s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 39 AND `field_id` = 7 LIMIT 1 [ RunTime:0.000468s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 39 AND `field_id` = 20 LIMIT 1 [ RunTime:0.000423s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 39 AND `field_id` = 21 LIMIT 1 [ RunTime:0.000456s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 39 AND `field_id` = 22 LIMIT 1 [ RunTime:0.000382s ]
SELECT `cf`.* FROM `cmf_portal_channel_bind` `cb` INNER JOIN `cmf_portal_channel_field` `cf` ON `cf`.`id`=`cb`.`field_id` WHERE `cb`.`typeid` = '2' ORDER BY `cf`.`list_order` [ RunTime:0.001165s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 38 AND `field_id` = 1 LIMIT 1 [ RunTime:0.000520s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 38 AND `field_id` = 2 LIMIT 1 [ RunTime:0.000531s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 38 AND `field_id` = 3 LIMIT 1 [ RunTime:0.000367s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 38 AND `field_id` = 4 LIMIT 1 [ RunTime:0.000496s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 38 AND `field_id` = 5 LIMIT 1 [ RunTime:0.000427s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 38 AND `field_id` = 6 LIMIT 1 [ RunTime:0.000495s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 38 AND `field_id` = 7 LIMIT 1 [ RunTime:0.000394s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 38 AND `field_id` = 20 LIMIT 1 [ RunTime:0.000452s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 38 AND `field_id` = 21 LIMIT 1 [ RunTime:0.000475s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 38 AND `field_id` = 22 LIMIT 1 [ RunTime:0.000498s ]
SELECT `cf`.* FROM `cmf_portal_channel_bind` `cb` INNER JOIN `cmf_portal_channel_field` `cf` ON `cf`.`id`=`cb`.`field_id` WHERE `cb`.`typeid` = '2' ORDER BY `cf`.`list_order` [ RunTime:0.001448s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 37 AND `field_id` = 1 LIMIT 1 [ RunTime:0.000575s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 37 AND `field_id` = 2 LIMIT 1 [ RunTime:0.000489s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 37 AND `field_id` = 3 LIMIT 1 [ RunTime:0.000494s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 37 AND `field_id` = 4 LIMIT 1 [ RunTime:0.000430s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 37 AND `field_id` = 5 LIMIT 1 [ RunTime:0.000446s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 37 AND `field_id` = 6 LIMIT 1 [ RunTime:0.000493s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 37 AND `field_id` = 7 LIMIT 1 [ RunTime:0.000634s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 37 AND `field_id` = 20 LIMIT 1 [ RunTime:0.000443s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 37 AND `field_id` = 21 LIMIT 1 [ RunTime:0.000430s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 37 AND `field_id` = 22 LIMIT 1 [ RunTime:0.000463s ]
SELECT `cf`.* FROM `cmf_portal_channel_bind` `cb` INNER JOIN `cmf_portal_channel_field` `cf` ON `cf`.`id`=`cb`.`field_id` WHERE `cb`.`typeid` = '2' ORDER BY `cf`.`list_order` [ RunTime:0.001223s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 36 AND `field_id` = 1 LIMIT 1 [ RunTime:0.000662s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 36 AND `field_id` = 2 LIMIT 1 [ RunTime:0.000540s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 36 AND `field_id` = 3 LIMIT 1 [ RunTime:0.000404s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 36 AND `field_id` = 4 LIMIT 1 [ RunTime:0.000439s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 36 AND `field_id` = 5 LIMIT 1 [ RunTime:0.000351s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 36 AND `field_id` = 6 LIMIT 1 [ RunTime:0.000497s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 36 AND `field_id` = 7 LIMIT 1 [ RunTime:0.000359s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 36 AND `field_id` = 20 LIMIT 1 [ RunTime:0.000338s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 36 AND `field_id` = 21 LIMIT 1 [ RunTime:0.000403s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 36 AND `field_id` = 22 LIMIT 1 [ RunTime:0.000377s ]
SELECT post.*,min(category_post.category_id) as category_id,min(category_post.list_order) as list_order FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = '1' AND `post`.`post_type` = '1' AND `post`.`delete_time` = '0' AND ( `post`.`recommended` = '1' ) AND ( `category_post`.`category_id` = '3' ) AND ( `post`.`published_time` > '0' AND `post`.`published_time` < '1628347118' ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 6 [ RunTime:0.001757s ]
SELECT `cf`.* FROM `cmf_portal_channel_bind` `cb` INNER JOIN `cmf_portal_channel_field` `cf` ON `cf`.`id`=`cb`.`field_id` WHERE `cb`.`typeid` = '3' ORDER BY `cf`.`list_order` [ RunTime:0.001270s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 35 AND `field_id` = 1 LIMIT 1 [ RunTime:0.000620s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 35 AND `field_id` = 2 LIMIT 1 [ RunTime:0.000494s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 35 AND `field_id` = 3 LIMIT 1 [ RunTime:0.000436s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 35 AND `field_id` = 4 LIMIT 1 [ RunTime:0.000520s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 35 AND `field_id` = 5 LIMIT 1 [ RunTime:0.000489s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 35 AND `field_id` = 6 LIMIT 1 [ RunTime:0.000482s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 35 AND `field_id` = 7 LIMIT 1 [ RunTime:0.000397s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 35 AND `field_id` = 20 LIMIT 1 [ RunTime:0.000441s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 35 AND `field_id` = 21 LIMIT 1 [ RunTime:0.000474s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 35 AND `field_id` = 22 LIMIT 1 [ RunTime:0.000423s ]
SELECT `cf`.* FROM `cmf_portal_channel_bind` `cb` INNER JOIN `cmf_portal_channel_field` `cf` ON `cf`.`id`=`cb`.`field_id` WHERE `cb`.`typeid` = '3' ORDER BY `cf`.`list_order` [ RunTime:0.002419s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 34 AND `field_id` = 1 LIMIT 1 [ RunTime:0.000583s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 34 AND `field_id` = 2 LIMIT 1 [ RunTime:0.000473s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 34 AND `field_id` = 3 LIMIT 1 [ RunTime:0.000334s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 34 AND `field_id` = 4 LIMIT 1 [ RunTime:0.000405s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 34 AND `field_id` = 5 LIMIT 1 [ RunTime:0.000381s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 34 AND `field_id` = 6 LIMIT 1 [ RunTime:0.000336s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 34 AND `field_id` = 7 LIMIT 1 [ RunTime:0.000333s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 34 AND `field_id` = 20 LIMIT 1 [ RunTime:0.000351s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 34 AND `field_id` = 21 LIMIT 1 [ RunTime:0.000370s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 34 AND `field_id` = 22 LIMIT 1 [ RunTime:0.000334s ]
SELECT `cf`.* FROM `cmf_portal_channel_bind` `cb` INNER JOIN `cmf_portal_channel_field` `cf` ON `cf`.`id`=`cb`.`field_id` WHERE `cb`.`typeid` = '3' ORDER BY `cf`.`list_order` [ RunTime:0.001360s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 33 AND `field_id` = 1 LIMIT 1 [ RunTime:0.000533s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 33 AND `field_id` = 2 LIMIT 1 [ RunTime:0.000380s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 33 AND `field_id` = 3 LIMIT 1 [ RunTime:0.000392s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 33 AND `field_id` = 4 LIMIT 1 [ RunTime:0.000357s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 33 AND `field_id` = 5 LIMIT 1 [ RunTime:0.000390s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 33 AND `field_id` = 6 LIMIT 1 [ RunTime:0.000346s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 33 AND `field_id` = 7 LIMIT 1 [ RunTime:0.000366s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 33 AND `field_id` = 20 LIMIT 1 [ RunTime:0.000395s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 33 AND `field_id` = 21 LIMIT 1 [ RunTime:0.000364s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 33 AND `field_id` = 22 LIMIT 1 [ RunTime:0.000392s ]
SELECT `cf`.* FROM `cmf_portal_channel_bind` `cb` INNER JOIN `cmf_portal_channel_field` `cf` ON `cf`.`id`=`cb`.`field_id` WHERE `cb`.`typeid` = '3' ORDER BY `cf`.`list_order` [ RunTime:0.001426s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 32 AND `field_id` = 1 LIMIT 1 [ RunTime:0.000633s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 32 AND `field_id` = 2 LIMIT 1 [ RunTime:0.000489s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 32 AND `field_id` = 3 LIMIT 1 [ RunTime:0.000491s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 32 AND `field_id` = 4 LIMIT 1 [ RunTime:0.000423s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 32 AND `field_id` = 5 LIMIT 1 [ RunTime:0.000422s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 32 AND `field_id` = 6 LIMIT 1 [ RunTime:0.000427s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 32 AND `field_id` = 7 LIMIT 1 [ RunTime:0.000447s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 32 AND `field_id` = 20 LIMIT 1 [ RunTime:0.000477s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 32 AND `field_id` = 21 LIMIT 1 [ RunTime:0.000438s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 32 AND `field_id` = 22 LIMIT 1 [ RunTime:0.000422s ]
SELECT `cf`.* FROM `cmf_portal_channel_bind` `cb` INNER JOIN `cmf_portal_channel_field` `cf` ON `cf`.`id`=`cb`.`field_id` WHERE `cb`.`typeid` = '3' ORDER BY `cf`.`list_order` [ RunTime:0.001265s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 31 AND `field_id` = 1 LIMIT 1 [ RunTime:0.000487s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 31 AND `field_id` = 2 LIMIT 1 [ RunTime:0.000428s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 31 AND `field_id` = 3 LIMIT 1 [ RunTime:0.000460s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 31 AND `field_id` = 4 LIMIT 1 [ RunTime:0.000459s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 31 AND `field_id` = 5 LIMIT 1 [ RunTime:0.000433s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 31 AND `field_id` = 6 LIMIT 1 [ RunTime:0.000432s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 31 AND `field_id` = 7 LIMIT 1 [ RunTime:0.000465s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 31 AND `field_id` = 20 LIMIT 1 [ RunTime:0.000454s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 31 AND `field_id` = 21 LIMIT 1 [ RunTime:0.000451s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 31 AND `field_id` = 22 LIMIT 1 [ RunTime:0.000439s ]
SELECT `cf`.* FROM `cmf_portal_channel_bind` `cb` INNER JOIN `cmf_portal_channel_field` `cf` ON `cf`.`id`=`cb`.`field_id` WHERE `cb`.`typeid` = '3' ORDER BY `cf`.`list_order` [ RunTime:0.001425s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 30 AND `field_id` = 1 LIMIT 1 [ RunTime:0.000528s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 30 AND `field_id` = 2 LIMIT 1 [ RunTime:0.000444s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 30 AND `field_id` = 3 LIMIT 1 [ RunTime:0.000369s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 30 AND `field_id` = 4 LIMIT 1 [ RunTime:0.000351s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 30 AND `field_id` = 5 LIMIT 1 [ RunTime:0.000365s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 30 AND `field_id` = 6 LIMIT 1 [ RunTime:0.000360s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 30 AND `field_id` = 7 LIMIT 1 [ RunTime:0.000395s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 30 AND `field_id` = 20 LIMIT 1 [ RunTime:0.000376s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 30 AND `field_id` = 21 LIMIT 1 [ RunTime:0.000419s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 30 AND `field_id` = 22 LIMIT 1 [ RunTime:0.000459s ]
SELECT post.*,min(category_post.category_id) as category_id,min(category_post.list_order) as list_order FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = '1' AND `post`.`post_type` = '1' AND `post`.`delete_time` = '0' AND ( `post`.`recommended` = '1' ) AND ( `category_post`.`category_id` = '4' ) AND ( `post`.`published_time` > '0' AND `post`.`published_time` < '1628347118' ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 6 [ RunTime:0.001773s ]
SELECT `cf`.* FROM `cmf_portal_channel_bind` `cb` INNER JOIN `cmf_portal_channel_field` `cf` ON `cf`.`id`=`cb`.`field_id` WHERE `cb`.`typeid` = '4' ORDER BY `cf`.`list_order` [ RunTime:0.001225s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 49 AND `field_id` = 1 LIMIT 1 [ RunTime:0.000901s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 49 AND `field_id` = 2 LIMIT 1 [ RunTime:0.000570s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 49 AND `field_id` = 3 LIMIT 1 [ RunTime:0.000590s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 49 AND `field_id` = 4 LIMIT 1 [ RunTime:0.000541s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 49 AND `field_id` = 5 LIMIT 1 [ RunTime:0.000478s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 49 AND `field_id` = 6 LIMIT 1 [ RunTime:0.000487s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 49 AND `field_id` = 7 LIMIT 1 [ RunTime:0.000493s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 49 AND `field_id` = 20 LIMIT 1 [ RunTime:0.000484s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 49 AND `field_id` = 21 LIMIT 1 [ RunTime:0.000552s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 49 AND `field_id` = 22 LIMIT 1 [ RunTime:0.000553s ]
SELECT `cf`.* FROM `cmf_portal_channel_bind` `cb` INNER JOIN `cmf_portal_channel_field` `cf` ON `cf`.`id`=`cb`.`field_id` WHERE `cb`.`typeid` = '4' ORDER BY `cf`.`list_order` [ RunTime:0.001263s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 48 AND `field_id` = 1 LIMIT 1 [ RunTime:0.000757s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 48 AND `field_id` = 2 LIMIT 1 [ RunTime:0.000618s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 48 AND `field_id` = 3 LIMIT 1 [ RunTime:0.000476s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 48 AND `field_id` = 4 LIMIT 1 [ RunTime:0.000470s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 48 AND `field_id` = 5 LIMIT 1 [ RunTime:0.000486s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 48 AND `field_id` = 6 LIMIT 1 [ RunTime:0.000542s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 48 AND `field_id` = 7 LIMIT 1 [ RunTime:0.000611s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 48 AND `field_id` = 20 LIMIT 1 [ RunTime:0.000683s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 48 AND `field_id` = 21 LIMIT 1 [ RunTime:0.000561s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 48 AND `field_id` = 22 LIMIT 1 [ RunTime:0.000496s ]
SELECT `cf`.* FROM `cmf_portal_channel_bind` `cb` INNER JOIN `cmf_portal_channel_field` `cf` ON `cf`.`id`=`cb`.`field_id` WHERE `cb`.`typeid` = '4' ORDER BY `cf`.`list_order` [ RunTime:0.001273s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 47 AND `field_id` = 1 LIMIT 1 [ RunTime:0.005141s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 47 AND `field_id` = 2 LIMIT 1 [ RunTime:0.000649s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 47 AND `field_id` = 3 LIMIT 1 [ RunTime:0.000465s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 47 AND `field_id` = 4 LIMIT 1 [ RunTime:0.000470s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 47 AND `field_id` = 5 LIMIT 1 [ RunTime:0.000430s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 47 AND `field_id` = 6 LIMIT 1 [ RunTime:0.000397s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 47 AND `field_id` = 7 LIMIT 1 [ RunTime:0.000368s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 47 AND `field_id` = 20 LIMIT 1 [ RunTime:0.000364s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 47 AND `field_id` = 21 LIMIT 1 [ RunTime:0.000446s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 47 AND `field_id` = 22 LIMIT 1 [ RunTime:0.000445s ]
SELECT `cf`.* FROM `cmf_portal_channel_bind` `cb` INNER JOIN `cmf_portal_channel_field` `cf` ON `cf`.`id`=`cb`.`field_id` WHERE `cb`.`typeid` = '4' ORDER BY `cf`.`list_order` [ RunTime:0.001343s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 46 AND `field_id` = 1 LIMIT 1 [ RunTime:0.000824s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 46 AND `field_id` = 2 LIMIT 1 [ RunTime:0.000530s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 46 AND `field_id` = 3 LIMIT 1 [ RunTime:0.000522s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 46 AND `field_id` = 4 LIMIT 1 [ RunTime:0.000414s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 46 AND `field_id` = 5 LIMIT 1 [ RunTime:0.000438s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 46 AND `field_id` = 6 LIMIT 1 [ RunTime:0.000365s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 46 AND `field_id` = 7 LIMIT 1 [ RunTime:0.000503s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 46 AND `field_id` = 20 LIMIT 1 [ RunTime:0.000398s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 46 AND `field_id` = 21 LIMIT 1 [ RunTime:0.000409s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 46 AND `field_id` = 22 LIMIT 1 [ RunTime:0.000375s ]
SELECT post.*,min(category_post.category_id) as category_id,min(category_post.list_order) as list_order FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = '1' AND `post`.`post_type` = '1' AND `post`.`delete_time` = '0' AND ( `post`.`recommended` = '1' ) AND ( `category_post`.`category_id` = '5' ) AND ( `post`.`published_time` > '0' AND `post`.`published_time` < '1628347118' ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 6 [ RunTime:0.001523s ]
SELECT `cf`.* FROM `cmf_portal_channel_bind` `cb` INNER JOIN `cmf_portal_channel_field` `cf` ON `cf`.`id`=`cb`.`field_id` WHERE `cb`.`typeid` = '5' ORDER BY `cf`.`list_order` [ RunTime:0.006870s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 51 AND `field_id` = 1 LIMIT 1 [ RunTime:0.000828s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 51 AND `field_id` = 2 LIMIT 1 [ RunTime:0.000555s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 51 AND `field_id` = 3 LIMIT 1 [ RunTime:0.000566s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 51 AND `field_id` = 4 LIMIT 1 [ RunTime:0.000499s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 51 AND `field_id` = 5 LIMIT 1 [ RunTime:0.000503s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 51 AND `field_id` = 6 LIMIT 1 [ RunTime:0.000590s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 51 AND `field_id` = 7 LIMIT 1 [ RunTime:0.000427s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 51 AND `field_id` = 20 LIMIT 1 [ RunTime:0.000497s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 51 AND `field_id` = 21 LIMIT 1 [ RunTime:0.000494s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 51 AND `field_id` = 22 LIMIT 1 [ RunTime:0.000568s ]
SELECT `cf`.* FROM `cmf_portal_channel_bind` `cb` INNER JOIN `cmf_portal_channel_field` `cf` ON `cf`.`id`=`cb`.`field_id` WHERE `cb`.`typeid` = '5' ORDER BY `cf`.`list_order` [ RunTime:0.001376s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 50 AND `field_id` = 1 LIMIT 1 [ RunTime:0.000698s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 50 AND `field_id` = 2 LIMIT 1 [ RunTime:0.000540s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 50 AND `field_id` = 3 LIMIT 1 [ RunTime:0.000443s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 50 AND `field_id` = 4 LIMIT 1 [ RunTime:0.000438s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 50 AND `field_id` = 5 LIMIT 1 [ RunTime:0.000422s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 50 AND `field_id` = 6 LIMIT 1 [ RunTime:0.000449s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 50 AND `field_id` = 7 LIMIT 1 [ RunTime:0.000422s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 50 AND `field_id` = 20 LIMIT 1 [ RunTime:0.000397s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 50 AND `field_id` = 21 LIMIT 1 [ RunTime:0.000432s ]
SELECT `data` FROM `cmf_portal_channel_post` WHERE `post_id` = 50 AND `field_id` = 22 LIMIT 1 [ RunTime:0.000440s ]
SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Control' LIMIT 1 [ RunTime:0.000494s ]