SHOW FULL COLUMNS FROM `tlk_plugin` [ RunTime:0.001411s ]
SELECT `config` FROM `tlk_plugin` WHERE `name` = 'SwitchTheme' LIMIT 1 [ RunTime:0.000324s ]
SHOW FULL COLUMNS FROM `tlk_portal_category` [ RunTime:0.001254s ]
SELECT * FROM `tlk_portal_category` WHERE `id` = 39 AND `status` = 1 LIMIT 1 [ RunTime:0.000389s ]
SHOW FULL COLUMNS FROM `tlk_theme_file` [ RunTime:0.001110s ]
SELECT `more` FROM `tlk_theme_file` WHERE `theme` = 'tlk' AND ( `is_public` = 1 OR `file` = 'portal/products' ) [ RunTime:0.000333s ]
SHOW FULL COLUMNS FROM `tlk_option` [ RunTime:0.001007s ]
SELECT `option_value` FROM `tlk_option` WHERE `option_name` = 'storage' AND `site_id` = 1 LIMIT 1 [ RunTime:0.000307s ]
SHOW FULL COLUMNS FROM `tlk_fragment` [ RunTime:0.001023s ]
SELECT * FROM `tlk_fragment` [ RunTime:0.000284s ]
SHOW FULL COLUMNS FROM `tlk_nav_menu` [ RunTime:0.001064s ]
SELECT * FROM `tlk_nav_menu` WHERE `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000377s ]
SELECT `nav_id` FROM `tlk_nav_menu` WHERE `id` = 1 AND `status` = 1 LIMIT 1 [ RunTime:0.000351s ]
SELECT * FROM `tlk_nav_menu` WHERE `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000349s ]
SELECT `nav_id` FROM `tlk_nav_menu` WHERE `id` = 2 AND `status` = 1 LIMIT 1 [ RunTime:0.000308s ]
SELECT * FROM `tlk_nav_menu` WHERE `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000343s ]
SELECT `nav_id` FROM `tlk_nav_menu` WHERE `id` = 38 AND `status` = 1 LIMIT 1 [ RunTime:0.000305s ]
SELECT * FROM `tlk_nav_menu` WHERE `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000363s ]
SELECT `nav_id` FROM `tlk_nav_menu` WHERE `id` = 39 AND `status` = 1 LIMIT 1 [ RunTime:0.000314s ]
SELECT * FROM `tlk_nav_menu` WHERE `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000334s ]
SELECT `nav_id` FROM `tlk_nav_menu` WHERE `id` = 40 AND `status` = 1 LIMIT 1 [ RunTime:0.000327s ]
SELECT * FROM `tlk_nav_menu` WHERE `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000338s ]
SELECT * FROM `tlk_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 39 ORDER BY `list_order` DESC [ RunTime:0.000437s ]
SELECT `path` FROM `tlk_portal_category` WHERE `id` = 39 LIMIT 1 [ RunTime:0.000311s ]
SELECT * FROM `tlk_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `path` LIKE '0-39-%' [ RunTime:0.000371s ]
SHOW FULL COLUMNS FROM `tlk_portal_post` [ RunTime:0.001552s ]
SELECT post.*,min(category_post.category_id) as category_id FROM `tlk_portal_post` `post` INNER JOIN `tlk_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 ( `category_post`.`category_id` IN ('39','40','41') ) AND ( `post`.`published_time` > '0' AND `post`.`published_time` < '1730251870' ) GROUP BY `post`.`id` ORDER BY list_order ASC,post.is_top DESC,post.recommended DESC,post.published_time DESC LIMIT 100 [ RunTime:0.000718s ]
SHOW FULL COLUMNS FROM `tlk_portal_category_post` [ RunTime:0.001131s ]
SELECT `tlk_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `tlk_portal_category` INNER JOIN `tlk_portal_category_post` `pivot` ON `pivot`.`category_id`=`tlk_portal_category`.`id` WHERE `pivot`.`post_id` = '227' [ RunTime:0.003359s ]
SELECT `tlk_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `tlk_portal_category` INNER JOIN `tlk_portal_category_post` `pivot` ON `pivot`.`category_id`=`tlk_portal_category`.`id` WHERE `pivot`.`post_id` = '228' [ RunTime:0.003285s ]
SELECT post.*,min(category_post.category_id) as category_id FROM `tlk_portal_post` `post` INNER JOIN `tlk_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 ( `category_post`.`category_id` IN ('33','34') ) AND ( `post`.`published_time` > '0' AND `post`.`published_time` < '1730251870' ) GROUP BY `post`.`id` ORDER BY list_order ASC,post.is_top DESC,post.recommended DESC,post.published_time DESC LIMIT 0,10 [ RunTime:0.095272s ]
SELECT `tlk_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `tlk_portal_category` INNER JOIN `tlk_portal_category_post` `pivot` ON `pivot`.`category_id`=`tlk_portal_category`.`id` WHERE `pivot`.`post_id` = '1191' [ RunTime:0.003337s ]
SELECT `tlk_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `tlk_portal_category` INNER JOIN `tlk_portal_category_post` `pivot` ON `pivot`.`category_id`=`tlk_portal_category`.`id` WHERE `pivot`.`post_id` = '225' [ RunTime:0.003282s ]
SELECT `tlk_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `tlk_portal_category` INNER JOIN `tlk_portal_category_post` `pivot` ON `pivot`.`category_id`=`tlk_portal_category`.`id` WHERE `pivot`.`post_id` = '237' [ RunTime:0.003273s ]
SELECT `tlk_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `tlk_portal_category` INNER JOIN `tlk_portal_category_post` `pivot` ON `pivot`.`category_id`=`tlk_portal_category`.`id` WHERE `pivot`.`post_id` = '1471' [ RunTime:0.003644s ]
SELECT `tlk_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `tlk_portal_category` INNER JOIN `tlk_portal_category_post` `pivot` ON `pivot`.`category_id`=`tlk_portal_category`.`id` WHERE `pivot`.`post_id` = '1444' [ RunTime:0.003275s ]
SELECT `tlk_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `tlk_portal_category` INNER JOIN `tlk_portal_category_post` `pivot` ON `pivot`.`category_id`=`tlk_portal_category`.`id` WHERE `pivot`.`post_id` = '6030' [ RunTime:0.003945s ]
SELECT `tlk_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `tlk_portal_category` INNER JOIN `tlk_portal_category_post` `pivot` ON `pivot`.`category_id`=`tlk_portal_category`.`id` WHERE `pivot`.`post_id` = '5998' [ RunTime:0.003291s ]
SELECT `tlk_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `tlk_portal_category` INNER JOIN `tlk_portal_category_post` `pivot` ON `pivot`.`category_id`=`tlk_portal_category`.`id` WHERE `pivot`.`post_id` = '9176' [ RunTime:0.005265s ]
SELECT `tlk_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `tlk_portal_category` INNER JOIN `tlk_portal_category_post` `pivot` ON `pivot`.`category_id`=`tlk_portal_category`.`id` WHERE `pivot`.`post_id` = '9184' [ RunTime:0.003275s ]
SELECT `tlk_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `tlk_portal_category` INNER JOIN `tlk_portal_category_post` `pivot` ON `pivot`.`category_id`=`tlk_portal_category`.`id` WHERE `pivot`.`post_id` = '9194' [ RunTime:0.003335s ]
SELECT post.*,min(category_post.category_id) as category_id FROM `tlk_portal_post` `post` INNER JOIN `tlk_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 ( `category_post`.`category_id` IN ('33','34') ) AND ( `post`.`published_time` > '0' AND `post`.`published_time` < '1730251870' ) GROUP BY `post`.`id` ORDER BY list_order ASC,post.is_top DESC,post.recommended DESC,post.published_time DESC LIMIT 10,10 [ RunTime:0.097154s ]
SELECT `tlk_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `tlk_portal_category` INNER JOIN `tlk_portal_category_post` `pivot` ON `pivot`.`category_id`=`tlk_portal_category`.`id` WHERE `pivot`.`post_id` = '9189' [ RunTime:0.003335s ]
SELECT `tlk_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `tlk_portal_category` INNER JOIN `tlk_portal_category_post` `pivot` ON `pivot`.`category_id`=`tlk_portal_category`.`id` WHERE `pivot`.`post_id` = '8933' [ RunTime:0.003309s ]
SELECT `tlk_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `tlk_portal_category` INNER JOIN `tlk_portal_category_post` `pivot` ON `pivot`.`category_id`=`tlk_portal_category`.`id` WHERE `pivot`.`post_id` = '8946' [ RunTime:0.003281s ]
SELECT `tlk_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `tlk_portal_category` INNER JOIN `tlk_portal_category_post` `pivot` ON `pivot`.`category_id`=`tlk_portal_category`.`id` WHERE `pivot`.`post_id` = '8973' [ RunTime:0.003272s ]
SELECT `tlk_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `tlk_portal_category` INNER JOIN `tlk_portal_category_post` `pivot` ON `pivot`.`category_id`=`tlk_portal_category`.`id` WHERE `pivot`.`post_id` = '8962' [ RunTime:0.003275s ]
SELECT `tlk_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `tlk_portal_category` INNER JOIN `tlk_portal_category_post` `pivot` ON `pivot`.`category_id`=`tlk_portal_category`.`id` WHERE `pivot`.`post_id` = '8975' [ RunTime:0.003281s ]
SELECT `tlk_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `tlk_portal_category` INNER JOIN `tlk_portal_category_post` `pivot` ON `pivot`.`category_id`=`tlk_portal_category`.`id` WHERE `pivot`.`post_id` = '9188' [ RunTime:0.003303s ]
SELECT `tlk_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `tlk_portal_category` INNER JOIN `tlk_portal_category_post` `pivot` ON `pivot`.`category_id`=`tlk_portal_category`.`id` WHERE `pivot`.`post_id` = '8997' [ RunTime:0.003275s ]
SELECT `tlk_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `tlk_portal_category` INNER JOIN `tlk_portal_category_post` `pivot` ON `pivot`.`category_id`=`tlk_portal_category`.`id` WHERE `pivot`.`post_id` = '9196' [ RunTime:0.003301s ]
SELECT `tlk_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `tlk_portal_category` INNER JOIN `tlk_portal_category_post` `pivot` ON `pivot`.`category_id`=`tlk_portal_category`.`id` WHERE `pivot`.`post_id` = '8903' [ RunTime:0.003279s ]
SELECT post.*,min(category_post.category_id) as category_id FROM `tlk_portal_post` `post` INNER JOIN `tlk_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 ( `category_post`.`category_id` IN ('33','34') ) AND ( `post`.`published_time` > '0' AND `post`.`published_time` < '1730251871' ) GROUP BY `post`.`id` ORDER BY list_order ASC,post.is_top DESC,post.recommended DESC,post.published_time DESC LIMIT 20,10 [ RunTime:0.096367s ]
SELECT `tlk_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `tlk_portal_category` INNER JOIN `tlk_portal_category_post` `pivot` ON `pivot`.`category_id`=`tlk_portal_category`.`id` WHERE `pivot`.`post_id` = '8921' [ RunTime:0.003444s ]
SELECT `tlk_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `tlk_portal_category` INNER JOIN `tlk_portal_category_post` `pivot` ON `pivot`.`category_id`=`tlk_portal_category`.`id` WHERE `pivot`.`post_id` = '8927' [ RunTime:0.003388s ]
SELECT `tlk_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `tlk_portal_category` INNER JOIN `tlk_portal_category_post` `pivot` ON `pivot`.`category_id`=`tlk_portal_category`.`id` WHERE `pivot`.`post_id` = '8925' [ RunTime:0.003361s ]
SELECT `tlk_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `tlk_portal_category` INNER JOIN `tlk_portal_category_post` `pivot` ON `pivot`.`category_id`=`tlk_portal_category`.`id` WHERE `pivot`.`post_id` = '8926' [ RunTime:0.003866s ]
SELECT `tlk_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `tlk_portal_category` INNER JOIN `tlk_portal_category_post` `pivot` ON `pivot`.`category_id`=`tlk_portal_category`.`id` WHERE `pivot`.`post_id` = '8937' [ RunTime:0.003897s ]
SELECT `tlk_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `tlk_portal_category` INNER JOIN `tlk_portal_category_post` `pivot` ON `pivot`.`category_id`=`tlk_portal_category`.`id` WHERE `pivot`.`post_id` = '9085' [ RunTime:0.003398s ]
SELECT `tlk_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `tlk_portal_category` INNER JOIN `tlk_portal_category_post` `pivot` ON `pivot`.`category_id`=`tlk_portal_category`.`id` WHERE `pivot`.`post_id` = '9098' [ RunTime:0.003306s ]
SELECT `tlk_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `tlk_portal_category` INNER JOIN `tlk_portal_category_post` `pivot` ON `pivot`.`category_id`=`tlk_portal_category`.`id` WHERE `pivot`.`post_id` = '9109' [ RunTime:0.003509s ]
SELECT `tlk_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `tlk_portal_category` INNER JOIN `tlk_portal_category_post` `pivot` ON `pivot`.`category_id`=`tlk_portal_category`.`id` WHERE `pivot`.`post_id` = '9198' [ RunTime:0.003291s ]
SELECT `tlk_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `tlk_portal_category` INNER JOIN `tlk_portal_category_post` `pivot` ON `pivot`.`category_id`=`tlk_portal_category`.`id` WHERE `pivot`.`post_id` = '9202' [ RunTime:0.003353s ]
SELECT post.*,min(category_post.category_id) as category_id FROM `tlk_portal_post` `post` INNER JOIN `tlk_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 `recommended` = 1 AND ( `category_post`.`category_id` IN ('33','34') ) AND ( `post`.`published_time` > '0' AND `post`.`published_time` < '1730251871' ) GROUP BY `post`.`id` ORDER BY list_order ASC,post.is_top DESC,post.recommended DESC,post.published_time DESC LIMIT 0,30 [ RunTime:0.042261s ]
SELECT `path` FROM `tlk_portal_category` WHERE `id` = 39 LIMIT 1 [ RunTime:0.000332s ]
SELECT * FROM `tlk_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `path` LIKE '0-39-%' [ RunTime:0.000392s ]
SELECT post.*,min(category_post.category_id) as category_id FROM `tlk_portal_post` `post` INNER JOIN `tlk_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 ( `category_post`.`category_id` IN ('39','40','41') ) AND ( `post`.`published_time` > '0' AND `post`.`published_time` < '1730251871' ) GROUP BY `post`.`id` ORDER BY list_order ASC,post.is_top DESC,post.recommended DESC,post.published_time DESC LIMIT 20 [ RunTime:0.000666s ]
SELECT `tlk_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `tlk_portal_category` INNER JOIN `tlk_portal_category_post` `pivot` ON `pivot`.`category_id`=`tlk_portal_category`.`id` WHERE `pivot`.`post_id` = '227' [ RunTime:0.003297s ]
SELECT `tlk_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `tlk_portal_category` INNER JOIN `tlk_portal_category_post` `pivot` ON `pivot`.`category_id`=`tlk_portal_category`.`id` WHERE `pivot`.`post_id` = '228' [ RunTime:0.003269s ]
SELECT * FROM `tlk_portal_post` WHERE `delete_time` = 0 AND `post_type` = 2 ORDER BY rand() LIMIT 30 [ RunTime:0.004278s ]