SHOW FULL COLUMNS FROM `tlk_plugin` [ RunTime:0.001458s ]
SELECT `config` FROM `tlk_plugin` WHERE `name` = 'SwitchTheme' LIMIT 1 [ RunTime:0.000758s ]
SHOW FULL COLUMNS FROM `tlk_portal_post` [ RunTime:0.003746s ]
SELECT * FROM `tlk_portal_post` WHERE `post_type` = 2 AND `post_status` = 1 AND `delete_time` = 0 AND `id` = 287 AND ( `published_time` > 0 AND `published_time` < 1725756651 ) LIMIT 1 [ RunTime:0.001121s ]
SHOW FULL COLUMNS FROM `tlk_theme_file` [ RunTime:0.002810s ]
SELECT `more` FROM `tlk_theme_file` WHERE `theme` = 'tlk' AND ( `is_public` = 1 OR `file` = 'portal/products_1' ) [ RunTime:0.000768s ]
SHOW FULL COLUMNS FROM `tlk_option` [ RunTime:0.002309s ]
SELECT `option_value` FROM `tlk_option` WHERE `option_name` = 'storage' AND `site_id` = 1 LIMIT 1 [ RunTime:0.000626s ]
SHOW FULL COLUMNS FROM `tlk_fragment` [ RunTime:0.002189s ]
SELECT * FROM `tlk_fragment` [ RunTime:0.000620s ]
SHOW FULL COLUMNS FROM `tlk_nav_menu` [ RunTime:0.002289s ]
SELECT * FROM `tlk_nav_menu` WHERE `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000786s ]
SELECT `nav_id` FROM `tlk_nav_menu` WHERE `id` = 1 AND `status` = 1 LIMIT 1 [ RunTime:0.000600s ]
SELECT * FROM `tlk_nav_menu` WHERE `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000498s ]
SELECT `nav_id` FROM `tlk_nav_menu` WHERE `id` = 2 AND `status` = 1 LIMIT 1 [ RunTime:0.000566s ]
SELECT * FROM `tlk_nav_menu` WHERE `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000488s ]
SELECT `nav_id` FROM `tlk_nav_menu` WHERE `id` = 38 AND `status` = 1 LIMIT 1 [ RunTime:0.000473s ]
SELECT * FROM `tlk_nav_menu` WHERE `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000567s ]
SELECT `nav_id` FROM `tlk_nav_menu` WHERE `id` = 39 AND `status` = 1 LIMIT 1 [ RunTime:0.000485s ]
SELECT * FROM `tlk_nav_menu` WHERE `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000563s ]
SELECT `nav_id` FROM `tlk_nav_menu` WHERE `id` = 40 AND `status` = 1 LIMIT 1 [ RunTime:0.000430s ]
SELECT * FROM `tlk_nav_menu` WHERE `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000554s ]
SHOW FULL COLUMNS FROM `tlk_portal_category` [ RunTime:0.002989s ]
SELECT * FROM `tlk_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 39 ORDER BY `list_order` DESC [ RunTime:0.001018s ]
SELECT `path` FROM `tlk_portal_category` WHERE `id` = 39 LIMIT 1 [ RunTime:0.000541s ]
SELECT * FROM `tlk_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `path` LIKE '0-39-%' [ RunTime:0.000696s ]
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` < '1725756652' ) GROUP BY `post`.`id` ORDER BY list_order ASC,post.is_top DESC,post.recommended DESC,post.published_time DESC LIMIT 100 [ RunTime:0.001544s ]
SHOW FULL COLUMNS FROM `tlk_portal_category_post` [ RunTime:0.002543s ]
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.008787s ]
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.005850s ]
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` < '1725756652' ) 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.088720s ]
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.003286s ]
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.003266s ]
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.003564s ]
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.003356s ]
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.003396s ]
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.003409s ]
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.003769s ]
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.009815s ]
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.007412s ]
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.006233s ]
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` < '1725756652' ) 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.089052s ]
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.003318s ]
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.003190s ]
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.003185s ]
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.003443s ]
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.003428s ]
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.003910s ]
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.003534s ]
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.003414s ]
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.003579s ]
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.003556s ]
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` < '1725756652' ) 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.086540s ]
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.003320s ]
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.003425s ]
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.004514s ]
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.003363s ]
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.003227s ]
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.003384s ]
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.003399s ]
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.003402s ]
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.003235s ]
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.003272s ]
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` < '1725756652' ) 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.031113s ]
SELECT `path` FROM `tlk_portal_category` WHERE `id` = 39 LIMIT 1 [ RunTime:0.000547s ]
SELECT * FROM `tlk_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `path` LIKE '0-39-%' [ RunTime:0.000589s ]
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` < '1725756652' ) GROUP BY `post`.`id` ORDER BY list_order ASC,post.is_top DESC,post.recommended DESC,post.published_time DESC LIMIT 20 [ RunTime:0.000858s ]
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.003237s ]
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.010571s ]
SELECT * FROM `tlk_portal_post` WHERE `delete_time` = 0 AND `post_type` = 2 ORDER BY rand() LIMIT 30 [ RunTime:0.010648s ]