SHOW FULL COLUMNS FROM `tlk_plugin` [ RunTime:0.004380s ]
SELECT `config` FROM `tlk_plugin` WHERE `name` = 'SwitchTheme' LIMIT 1 [ RunTime:0.001245s ]
SHOW FULL COLUMNS FROM `tlk_portal_post` [ RunTime:0.004152s ]
SELECT * FROM `tlk_portal_post` WHERE `post_type` = 2 AND `post_status` = 1 AND `delete_time` = 0 AND `id` = 303 AND ( `published_time` > 0 AND `published_time` < 1725762850 ) LIMIT 1 [ RunTime:0.001746s ]
SHOW FULL COLUMNS FROM `tlk_theme_file` [ RunTime:0.003048s ]
SELECT `more` FROM `tlk_theme_file` WHERE `theme` = 'tlk' AND ( `is_public` = 1 OR `file` = 'portal/products_1' ) [ RunTime:0.001176s ]
SHOW FULL COLUMNS FROM `tlk_option` [ RunTime:0.002924s ]
SELECT `option_value` FROM `tlk_option` WHERE `option_name` = 'storage' AND `site_id` = 1 LIMIT 1 [ RunTime:0.001066s ]
SHOW FULL COLUMNS FROM `tlk_fragment` [ RunTime:0.002478s ]
SELECT * FROM `tlk_fragment` [ RunTime:0.001036s ]
SHOW FULL COLUMNS FROM `tlk_nav_menu` [ RunTime:0.002418s ]
SELECT * FROM `tlk_nav_menu` WHERE `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.001233s ]
SELECT `nav_id` FROM `tlk_nav_menu` WHERE `id` = 1 AND `status` = 1 LIMIT 1 [ RunTime:0.000751s ]
SELECT * FROM `tlk_nav_menu` WHERE `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000747s ]
SELECT `nav_id` FROM `tlk_nav_menu` WHERE `id` = 2 AND `status` = 1 LIMIT 1 [ RunTime:0.000574s ]
SELECT * FROM `tlk_nav_menu` WHERE `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000686s ]
SELECT `nav_id` FROM `tlk_nav_menu` WHERE `id` = 38 AND `status` = 1 LIMIT 1 [ RunTime:0.000554s ]
SELECT * FROM `tlk_nav_menu` WHERE `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000671s ]
SELECT `nav_id` FROM `tlk_nav_menu` WHERE `id` = 39 AND `status` = 1 LIMIT 1 [ RunTime:0.000560s ]
SELECT * FROM `tlk_nav_menu` WHERE `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000680s ]
SELECT `nav_id` FROM `tlk_nav_menu` WHERE `id` = 40 AND `status` = 1 LIMIT 1 [ RunTime:0.000847s ]
SELECT * FROM `tlk_nav_menu` WHERE `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000758s ]
SHOW FULL COLUMNS FROM `tlk_portal_category` [ RunTime:0.003925s ]
SELECT * FROM `tlk_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 39 ORDER BY `list_order` DESC [ RunTime:0.001839s ]
SELECT `path` FROM `tlk_portal_category` WHERE `id` = 39 LIMIT 1 [ RunTime:0.000643s ]
SELECT * FROM `tlk_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `path` LIKE '0-39-%' [ RunTime:0.000846s ]
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` < '1725762850' ) GROUP BY `post`.`id` ORDER BY list_order ASC,post.is_top DESC,post.recommended DESC,post.published_time DESC LIMIT 100 [ RunTime:0.002670s ]
SHOW FULL COLUMNS FROM `tlk_portal_category_post` [ RunTime:0.002600s ]
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.009377s ]
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.006944s ]
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` < '1725762850' ) 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.179669s ]
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.003492s ]
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.003345s ]
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.003300s ]
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.003243s ]
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.003489s ]
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.003403s ]
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.003619s ]
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.003586s ]
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.003722s ]
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.003896s ]
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` < '1725762851' ) 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.098396s ]
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.003503s ]
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.003231s ]
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.003248s ]
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.003217s ]
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.003234s ]
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.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` = '9188' [ RunTime:0.003231s ]
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.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` = '9196' [ 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` = '8903' [ RunTime:0.003487s ]
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` < '1725762851' ) 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.098278s ]
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.003629s ]
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.003333s ]
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.003355s ]
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.003441s ]
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.003436s ]
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.003344s ]
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.003350s ]
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.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` = '9198' [ RunTime:0.003439s ]
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.003405s ]
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` < '1725762851' ) 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.038701s ]
SELECT `path` FROM `tlk_portal_category` WHERE `id` = 39 LIMIT 1 [ RunTime:0.000657s ]
SELECT * FROM `tlk_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `path` LIKE '0-39-%' [ RunTime:0.000626s ]
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` < '1725762851' ) GROUP BY `post`.`id` ORDER BY list_order ASC,post.is_top DESC,post.recommended DESC,post.published_time DESC LIMIT 20 [ RunTime:0.000956s ]
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.003299s ]
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.004084s ]
SELECT * FROM `tlk_portal_post` WHERE `delete_time` = 0 AND `post_type` = 2 ORDER BY rand() LIMIT 30 [ RunTime:0.005686s ]