SELECT `name` FROM `lan_addon` WHERE `state` = 1 ORDER BY `is_home` DESC,`id` ASC [ RunTime:0.003841s ]
SELECT `name` FROM `lan_addon` WHERE `is_home` = 1 AND `state` = 1 LIMIT 1 [ RunTime:0.004670s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'archives' [ RunTime:0.006563s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'archives' [ RunTime:0.003836s ]
SHOW INDEX FROM `lan_cms_archives_translation` [ RunTime:0.016783s ]
SELECT COUNT(*) AS think_count FROM `lan_cms_archives` `a` INNER JOIN `lan_cms_archives_translation` `t` ON `t`.`archives_id`=a.id AND t.lang = 'en' WHERE ( `a`.`status` = 'normal' AND `a`.`publish_time` <= '1793628262' AND ( MATCH(`t`.`title`, `t`.`keywords`, `t`.`description`) AGAINST ('cold brew' IN BOOLEAN MODE) ) ) AND `a`.`delete_time` IS NULL [ RunTime:0.008486s ]
SELECT `a`.*,`t`.`title`,`t`.`slug`,`t`.`seo_title`,`t`.`keywords`,`t`.`description`,`t`.`content`,`t`.`cover_image`,`t`.`is_translated` FROM `lan_cms_archives` `a` INNER JOIN `lan_cms_archives_translation` `t` ON `t`.`archives_id`=a.id AND t.lang = 'en' WHERE ( `a`.`status` = 'normal' AND `a`.`publish_time` <= '1793628262' AND ( MATCH(`t`.`title`, `t`.`keywords`, `t`.`description`) AGAINST ('cold brew' IN BOOLEAN MODE) ) ) AND `a`.`delete_time` IS NULL ORDER BY `a`.`weigh` DESC,`a`.`id` DESC LIMIT 0,15 [ RunTime:0.010811s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'archives' [ RunTime:0.005828s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'archives' [ RunTime:0.003130s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'archives' [ RunTime:0.003136s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'archives' [ RunTime:0.001552s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'archives' [ RunTime:0.003536s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'archives' [ RunTime:0.002282s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'archives' [ RunTime:0.003920s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'archives' [ RunTime:0.003140s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.004684s ]
SELECT * FROM `lan_cms_category` WHERE ( `id` IN (2,3,4,6,8,10,11) ) ORDER BY `id` DESC LIMIT 1000 [ RunTime:0.003278s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.002673s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.001900s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.002793s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.002044s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.001942s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.003179s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'category' [ RunTime:0.002396s ]
SELECT * FROM `lan_cms_category_translation` WHERE ( `category_id` IN (11,10,8,6,4,3,2) ) ORDER BY `id` DESC LIMIT 1000 [ RunTime:0.004199s ]
SELECT * FROM `lan_cms_archives_translation` WHERE `lang` = 'en' AND ( `archives_id` IN (1,2,3,5,7,8,10,12) ) ORDER BY `id` DESC LIMIT 1000 [ RunTime:0.003474s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.001488s ]
SELECT tg.id, tg.weigh, t.name, t.slug, COUNT(atr.id) as article_count FROM `lan_cms_tags` `tg` INNER JOIN `lan_cms_tags_translation` `t` ON `t`.`tags_id`=tg.id AND t.lang = 'en' LEFT JOIN `lan_cms_archives_tags` `at` ON `at`.`tags_id`=`tg`.`id` LEFT JOIN `lan_cms_archives` `a` ON `a`.`id`=`at`.`archives_id` LEFT JOIN `lan_cms_archives_translation` `atr` ON `atr`.`archives_id`=a.id AND atr.lang = 'en' GROUP BY `tg`.`id`,`t`.`name`,`t`.`slug`,`tg`.`weigh` ORDER BY `tg`.`weigh` DESC LIMIT 20 [ RunTime:0.003134s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.001917s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.002242s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.001222s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.002494s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.001286s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.001132s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.000988s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.001171s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.001537s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.001369s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.001785s ]
SELECT `name` FROM `lan_cms_model_field` WHERE `source` = 'tags' [ RunTime:0.002489s ]
SELECT * FROM `lan_cms_tags_translation` WHERE `tags_id` = 1 [ RunTime:0.001507s ]
SELECT * FROM `lan_cms_tags_translation` WHERE `tags_id` = 2 [ RunTime:0.002408s ]
SELECT * FROM `lan_cms_tags_translation` WHERE `tags_id` = 3 [ RunTime:0.001954s ]
SELECT * FROM `lan_cms_tags_translation` WHERE `tags_id` = 4 [ RunTime:0.001262s ]
SELECT * FROM `lan_cms_tags_translation` WHERE `tags_id` = 5 [ RunTime:0.001824s ]
SELECT * FROM `lan_cms_tags_translation` WHERE `tags_id` = 6 [ RunTime:0.002751s ]
SELECT * FROM `lan_cms_tags_translation` WHERE `tags_id` = 7 [ RunTime:0.001770s ]
SELECT * FROM `lan_cms_tags_translation` WHERE `tags_id` = 8 [ RunTime:0.001634s ]
SELECT * FROM `lan_cms_tags_translation` WHERE `tags_id` = 9 [ RunTime:0.002087s ]
SELECT * FROM `lan_cms_tags_translation` WHERE `tags_id` = 10 [ RunTime:0.001472s ]
SELECT * FROM `lan_cms_tags_translation` WHERE `tags_id` = 11 [ RunTime:0.002044s ]
SELECT * FROM `lan_cms_tags_translation` WHERE `tags_id` = 12 [ RunTime:0.002735s ]