SHOW FULL COLUMNS FROM `config` [ RunTime:0.003725s ]
SELECT * FROM `config` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000474s ]
SHOW FULL COLUMNS FROM `system` [ RunTime:0.000659s ]
SELECT * FROM `system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000319s ]
SHOW FULL COLUMNS FROM `label` [ RunTime:0.000538s ]
SELECT * FROM `label` ORDER BY `id` ASC [ RunTime:0.000208s ]
SHOW FULL COLUMNS FROM `category` [ RunTime:0.000608s ]
SELECT * FROM `category` WHERE `status` = 1 AND `pid` = -1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000442s ]
UPDATE `category` SET `is_dow` = 0 WHERE `id` > 0 [ RunTime:0.046732s ]
SELECT `pid` FROM `category` WHERE `pid` <> -1 [ RunTime:0.003482s ]
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.032333s ]
SELECT * FROM `config` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001049s ]
SHOW FULL COLUMNS FROM `content` [ RunTime:0.001288s ]
SELECT * FROM `content` WHERE `id` = ?country=%E4%B8%B9%E9%BA%A6&month=202707 OR `filename` = '?country=%E4%B8%B9%E9%BA%A6&month=202707' LIMIT 1 [ RunTime:0.007835s ]
SELECT * FROM `category` WHERE `filename` = 'energy' OR `link` = '/energy/' LIMIT 1 [ RunTime:0.000706s ]
SHOW FULL COLUMNS FROM `model` [ RunTime:0.000568s ]
SELECT * FROM `model` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000458s ]
SELECT * FROM `system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.002852s ]
SELECT * FROM `system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.006113s ]
SHOW FULL COLUMNS FROM `content_ext` [ RunTime:0.000568s ]
SELECT `content` FROM `content_ext` WHERE `field` = 'ext_country' AND `value` = '丹麦' [ RunTime:0.148086s ]
SELECT COUNT(*) AS think_count FROM `content` WHERE `status` = 1 AND `scode` = 225 AND ( `date` LIKE '2027.07%' OR ( `date` LIKE '2027-07%' ) ) AND `id` IN (497,1369,1551,1556,1647,1656,1863,2446,2920,3056,3096,3748,4500,5040,5362,5496,5671,6293,6326,6465,6922,7421,7525) [ RunTime:0.000649s ]
SELECT `content` FROM `content_ext` WHERE `field` = 'ext_country' AND `value` = '丹麦' [ RunTime:0.122610s ]
SELECT * FROM `content` WHERE `status` = 1 AND `scode` = 225 AND ( `date` LIKE '2027.07%' OR ( `date` LIKE '2027-07%' ) ) AND `id` IN (497,1369,1551,1556,1647,1656,1863,2446,2920,3056,3096,3748,4500,5040,5362,5496,5671,6293,6326,6465,6922,7421,7525) ORDER BY `sort` ASC,`id` DESC LIMIT 0,15 [ RunTime:0.011042s ]
SELECT * FROM `category` WHERE `pid` = 2 AND `status` = 1 ORDER BY `sort` ASC,`id` ASC LIMIT 0,10 [ RunTime:0.000479s ]
SELECT * FROM `category` WHERE `pid` = 337 AND `status` = 1 ORDER BY `sort` ASC,`id` ASC LIMIT 0,10 [ RunTime:0.000391s ]
SELECT * FROM `category` WHERE `pid` = 338 AND `status` = 1 ORDER BY `sort` ASC,`id` ASC LIMIT 0,10 [ RunTime:0.000266s ]
SELECT `value` FROM `content_ext` WHERE `field` = 'ext_country' AND `value` <> '' GROUP BY `value` [ RunTime:0.079054s ]
SELECT * FROM `category` WHERE `pid` = 2 AND `status` = 1 ORDER BY `sort` ASC,`id` ASC LIMIT 0,10 [ RunTime:0.043624s ]
SELECT * FROM `category` WHERE `pid` = 337 AND `status` = 1 ORDER BY `sort` ASC,`id` ASC LIMIT 0,10 [ RunTime:0.052029s ]
SELECT * FROM `category` WHERE `pid` = 338 AND `status` = 1 ORDER BY `sort` ASC,`id` ASC LIMIT 0,10 [ RunTime:0.001310s ]