SHOW FULL COLUMNS FROM `config` [ RunTime:0.011196s ]
SELECT * FROM `config` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000333s ]
SHOW FULL COLUMNS FROM `system` [ RunTime:0.000475s ]
SELECT * FROM `system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000281s ]
SHOW FULL COLUMNS FROM `label` [ RunTime:0.000365s ]
SELECT * FROM `label` ORDER BY `id` ASC [ RunTime:0.000176s ]
SHOW FULL COLUMNS FROM `category` [ RunTime:0.000511s ]
SELECT * FROM `category` WHERE `status` = 1 AND `pid` = -1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000363s ]
UPDATE `category` SET `is_dow` = 0 WHERE `id` > 0 [ RunTime:0.026697s ]
SELECT `pid` FROM `category` WHERE `pid` <> -1 [ RunTime:0.000413s ]
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.017173s ]
SELECT * FROM `config` WHERE `id` = 1 LIMIT 1 [ RunTime:0.004457s ]
SHOW FULL COLUMNS FROM `content` [ RunTime:0.000567s ]
SELECT * FROM `content` WHERE `id` = ?country=%E8%82%AF%E5%B0%BC%E4%BA%9A&month=202706 OR `filename` = '?country=%E8%82%AF%E5%B0%BC%E4%BA%9A&month=202706' LIMIT 1 [ RunTime:0.014152s ]
SELECT * FROM `category` WHERE `filename` = 'water' OR `link` = '/water/' LIMIT 1 [ RunTime:0.009237s ]
SHOW FULL COLUMNS FROM `model` [ RunTime:0.000457s ]
SELECT * FROM `model` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000218s ]
SELECT * FROM `system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000204s ]
SELECT * FROM `system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000236s ]
SHOW FULL COLUMNS FROM `content_ext` [ RunTime:0.000435s ]
SELECT `content` FROM `content_ext` WHERE `field` = 'ext_country' AND `value` = '肯尼亚' [ RunTime:0.173946s ]
SELECT COUNT(*) AS think_count FROM `content` WHERE `status` = 1 AND `scode` = 227 AND ( `date` LIKE '2027.06%' OR ( `date` LIKE '2027-06%' ) ) AND `id` IN (78,118,417,423,697,3939,5306,5349,5839,6142,6205,6206,6220,6365,6367,6394,6444,6446,6447,6475,6680,6705,6805,6808,7003,7365,7374) [ RunTime:0.034036s ]
SELECT `content` FROM `content_ext` WHERE `field` = 'ext_country' AND `value` = '肯尼亚' [ RunTime:0.118957s ]
SELECT * FROM `content` WHERE `status` = 1 AND `scode` = 227 AND ( `date` LIKE '2027.06%' OR ( `date` LIKE '2027-06%' ) ) AND `id` IN (78,118,417,423,697,3939,5306,5349,5839,6142,6205,6206,6220,6365,6367,6394,6444,6446,6447,6475,6680,6705,6805,6808,7003,7365,7374) ORDER BY `sort` ASC,`id` DESC LIMIT 0,15 [ RunTime:0.004349s ]
SELECT * FROM `category` WHERE `pid` = 2 AND `status` = 1 ORDER BY `sort` ASC,`id` ASC LIMIT 0,10 [ RunTime:0.016469s ]
SELECT * FROM `category` WHERE `pid` = 337 AND `status` = 1 ORDER BY `sort` ASC,`id` ASC LIMIT 0,10 [ RunTime:0.000770s ]
SELECT * FROM `category` WHERE `pid` = 338 AND `status` = 1 ORDER BY `sort` ASC,`id` ASC LIMIT 0,10 [ RunTime:0.000682s ]
SELECT `value` FROM `content_ext` WHERE `field` = 'ext_country' AND `value` <> '' GROUP BY `value` [ RunTime:0.219761s ]
SELECT * FROM `category` WHERE `pid` = 2 AND `status` = 1 ORDER BY `sort` ASC,`id` ASC LIMIT 0,10 [ RunTime:0.029763s ]
SELECT * FROM `category` WHERE `pid` = 337 AND `status` = 1 ORDER BY `sort` ASC,`id` ASC LIMIT 0,10 [ RunTime:0.028532s ]
SELECT * FROM `category` WHERE `pid` = 338 AND `status` = 1 ORDER BY `sort` ASC,`id` ASC LIMIT 0,10 [ RunTime:0.044663s ]