SHOW FULL COLUMNS FROM `config` [ RunTime:0.000507s ]
SELECT * FROM `config` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000260s ]
SHOW FULL COLUMNS FROM `system` [ RunTime:0.000383s ]
SELECT * FROM `system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000206s ]
SHOW FULL COLUMNS FROM `label` [ RunTime:0.000291s ]
SELECT * FROM `label` ORDER BY `id` ASC [ RunTime:0.000161s ]
SHOW FULL COLUMNS FROM `category` [ RunTime:0.000464s ]
SELECT * FROM `category` WHERE `status` = 1 AND `pid` = -1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000287s ]
UPDATE `category` SET `is_dow` = 0 WHERE `id` > 0 [ RunTime:0.001625s ]
SELECT `pid` FROM `category` WHERE `pid` <> -1 [ RunTime:0.000251s ]
UPDATE `category` SET `is_dow` = 1 WHERE `id` IN (1,24,23,22,21,20,19,18,17,16,15,14,13,12,11,10,4,3,25,26,27,28,29,30,5,6,7,8,9,2) [ RunTime:0.002833s ]
SELECT * FROM `config` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000218s ]
SELECT * FROM `system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000207s ]
SELECT * FROM `system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000238s ]
SHOW FULL COLUMNS FROM `content` [ RunTime:0.000404s ]
SELECT COUNT(*) AS think_count FROM `content` WHERE `status` = 1 AND ( ( date REGEXP '^[0-9]{4}\\.[0-9]{2}\\.[0-9]{2}~' AND REPLACE(SUBSTRING_INDEX(date,'~',1), '.', '-') >= '2026-06-19' ) OR ( date NOT REGEXP '^[0-9]{4}\\.[0-9]{2}\\.[0-9]{2}~' AND date >= '2026.06' ) ) [ RunTime:0.027067s ]
SELECT `id`,`name`,`ico`,`date`,`scode`,`click` FROM `content` WHERE `status` = 1 AND ( ( date REGEXP '^[0-9]{4}\\.[0-9]{2}\\.[0-9]{2}~' AND REPLACE(SUBSTRING_INDEX(date,'~',1), '.', '-') >= '2026-06-19' ) OR ( date NOT REGEXP '^[0-9]{4}\\.[0-9]{2}\\.[0-9]{2}~' AND date >= '2026.06' ) ) ORDER BY `sort` ASC,`date` ASC,`id` DESC LIMIT 1740,20 [ RunTime:0.042927s ]
SHOW FULL COLUMNS FROM `content_ext` [ RunTime:0.000589s ]
SELECT * FROM `content_ext` WHERE `content` IN (6555,6556,6557,6558,6559,6560,6561,6562,6563,6564,6565,6566,6567,6569,6570,6571,6572,6573,6574,6575) AND `field` IN ('ext_country','ext_city','ext_address') [ RunTime:0.044000s ]
SELECT `id`,`name`,`filename`,`link` FROM `category` WHERE `id` IN (336,196,230,238,271,201,187,333,265,318,256,327,274,198,334,262,207,214,225) [ RunTime:0.000531s ]
SELECT value, COUNT(*) as cnt FROM `content_ext` WHERE `field` = 'ext_country' AND `value` <> '' GROUP BY `value` ORDER BY `cnt` DESC LIMIT 8 [ RunTime:0.095518s ]
SELECT * FROM `category` WHERE `pid` = 2 AND `status` = 1 ORDER BY `sort` ASC,`id` ASC LIMIT 0,10 [ RunTime:0.000411s ]
SELECT * FROM `category` WHERE `pid` = 337 AND `status` = 1 ORDER BY `sort` ASC,`id` ASC LIMIT 0,10 [ RunTime:0.000367s ]
SELECT * FROM `category` WHERE `pid` = 338 AND `status` = 1 ORDER BY `sort` ASC,`id` ASC LIMIT 0,10 [ RunTime:0.000340s ]
SELECT * FROM `category` WHERE `pid` = 2 AND `status` = 1 ORDER BY `sort` ASC,`id` ASC LIMIT 0,10 [ RunTime:0.000333s ]
SELECT * FROM `category` WHERE `pid` = 337 AND `status` = 1 ORDER BY `sort` ASC,`id` ASC LIMIT 0,10 [ RunTime:0.000421s ]
SELECT * FROM `category` WHERE `pid` = 338 AND `status` = 1 ORDER BY `sort` ASC,`id` ASC LIMIT 0,10 [ RunTime:0.000348s ]