SHOW FULL COLUMNS FROM `config` [ RunTime:0.000538s ]
SELECT * FROM `config` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000336s ]
SHOW FULL COLUMNS FROM `system` [ RunTime:0.000445s ]
SELECT * FROM `system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000245s ]
SHOW FULL COLUMNS FROM `label` [ RunTime:0.000342s ]
SELECT * FROM `label` ORDER BY `id` ASC [ RunTime:0.000183s ]
SHOW FULL COLUMNS FROM `category` [ RunTime:0.000494s ]
SELECT * FROM `category` WHERE `status` = 1 AND `pid` = -1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000362s ]
UPDATE `category` SET `is_dow` = 0 WHERE `id` > 0 [ RunTime:0.015801s ]
SELECT `pid` FROM `category` WHERE `pid` <> -1 [ RunTime:0.000404s ]
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.022161s ]
SELECT * FROM `config` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000362s ]
SELECT * FROM `system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000221s ]
SELECT * FROM `system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000219s ]
SHOW FULL COLUMNS FROM `content` [ RunTime:0.000588s ]
SHOW FULL COLUMNS FROM `content_ext` [ RunTime:0.000370s ]
SELECT `content` FROM `content_ext` WHERE `field` = 'ext_country' AND `value` = '西班牙' [ RunTime:0.067232s ]
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-04-06' ) OR ( date NOT REGEXP '^[0-9]{4}\\.[0-9]{2}\\.[0-9]{2}~' AND date >= '2026.04' ) ) AND `id` IN (150,161,175,187,188,190,223,310,453,475,503,539,550,712,889,909,915,1003,1017,1052,1056,1063,1075,1086,1094,1096,1124,1133,1145,1211,1254,1281,1282,1298,1318,1320,1329,1331,1332,1409,1410,1424,1429,1451,1483,1485,1507,1509,1515,1546,1547,1548,1592,1636,1645,1668,1683,1695,1776,1778,1785,1841,1928,1953,1954,1959,1965,1972,1981,1988,2053,2125,2137,2148,2149,2155,2233,2234,2235,2236,2280,2281,2282,2283,2284,2285,2315,2352,2353,2354,2355,2356,2357,2358,2426,2427,2428,2444,2445,2457,2458,2459,2460,2461,2462,2523,2563,2564,2591,2592,2717,2719,2760,2764,2840,2938,2966,2970,3008,3033,3087,3093,3110,3193,3225,3237,3239,3394,3483,3494,3511,3532,3597,3615,3622,3630,3648,3687,3698,3703,3775,3810,3901,3916,3928,3969,4014,4015,4048,4100,4130,4208,4210,4262,4264,4274,4289,4419,4436,4505,4569,4582,4608,4609,4611,4621,4628,4631,4637,4672,4683,4685,4789,4849,4917,4920,4934,4966,4968,4985,5019,5224,5238,5248,5296,5300,5309,5331,5358,5449,5455,5490,5505,5506,5511,5519,5545,5596,5603,5605,5630,5643,5653,5680,5831,5879,5919,6138,6168,6426,6516,6585,6601,6608,6724,6728,6748,6755,6810,6813,6849,6852,6853,6875,6885,6924,6940,6980,7019,7031,7060,7078,7080,7140,7230,7245,7247,7288,7378,7471,7521,7556,7558,7564,7595,7624,7679,7716,7738) [ RunTime:0.009623s ]
SELECT `content` FROM `content_ext` WHERE `field` = 'ext_country' AND `value` = '西班牙' [ RunTime:0.048281s ]
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-04-06' ) OR ( date NOT REGEXP '^[0-9]{4}\\.[0-9]{2}\\.[0-9]{2}~' AND date >= '2026.04' ) ) AND `id` IN (150,161,175,187,188,190,223,310,453,475,503,539,550,712,889,909,915,1003,1017,1052,1056,1063,1075,1086,1094,1096,1124,1133,1145,1211,1254,1281,1282,1298,1318,1320,1329,1331,1332,1409,1410,1424,1429,1451,1483,1485,1507,1509,1515,1546,1547,1548,1592,1636,1645,1668,1683,1695,1776,1778,1785,1841,1928,1953,1954,1959,1965,1972,1981,1988,2053,2125,2137,2148,2149,2155,2233,2234,2235,2236,2280,2281,2282,2283,2284,2285,2315,2352,2353,2354,2355,2356,2357,2358,2426,2427,2428,2444,2445,2457,2458,2459,2460,2461,2462,2523,2563,2564,2591,2592,2717,2719,2760,2764,2840,2938,2966,2970,3008,3033,3087,3093,3110,3193,3225,3237,3239,3394,3483,3494,3511,3532,3597,3615,3622,3630,3648,3687,3698,3703,3775,3810,3901,3916,3928,3969,4014,4015,4048,4100,4130,4208,4210,4262,4264,4274,4289,4419,4436,4505,4569,4582,4608,4609,4611,4621,4628,4631,4637,4672,4683,4685,4789,4849,4917,4920,4934,4966,4968,4985,5019,5224,5238,5248,5296,5300,5309,5331,5358,5449,5455,5490,5505,5506,5511,5519,5545,5596,5603,5605,5630,5643,5653,5680,5831,5879,5919,6138,6168,6426,6516,6585,6601,6608,6724,6728,6748,6755,6810,6813,6849,6852,6853,6875,6885,6924,6940,6980,7019,7031,7060,7078,7080,7140,7230,7245,7247,7288,7378,7471,7521,7556,7558,7564,7595,7624,7679,7716,7738) ORDER BY `sort` ASC,`date` ASC,`id` DESC LIMIT 40,20 [ RunTime:0.024744s ]
SELECT * FROM `content_ext` WHERE `content` IN (5238,5248,5605,5643,5653,5680,5831,5879,5919,6138,6168,6426,6516,6585,6601,6608,6724,6728,6748,6755) AND `field` IN ('ext_country','ext_city','ext_address') [ RunTime:0.038289s ]
SELECT `id`,`name`,`filename`,`link` FROM `category` WHERE `id` IN (213,300,243,218,229,307,238,241,203,239,242,198,225,299,214,220) [ RunTime:0.002336s ]
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.175884s ]
SELECT * FROM `category` WHERE `pid` = 2 AND `status` = 1 ORDER BY `sort` ASC,`id` ASC LIMIT 0,10 [ RunTime:0.018642s ]
SELECT * FROM `category` WHERE `pid` = 337 AND `status` = 1 ORDER BY `sort` ASC,`id` ASC LIMIT 0,10 [ RunTime:0.003054s ]
SELECT * FROM `category` WHERE `pid` = 338 AND `status` = 1 ORDER BY `sort` ASC,`id` ASC LIMIT 0,10 [ RunTime:0.000335s ]
SELECT * FROM `category` WHERE `pid` = 2 AND `status` = 1 ORDER BY `sort` ASC,`id` ASC LIMIT 0,10 [ RunTime:0.000318s ]
SELECT * FROM `category` WHERE `pid` = 337 AND `status` = 1 ORDER BY `sort` ASC,`id` ASC LIMIT 0,10 [ RunTime:0.000259s ]
SELECT * FROM `category` WHERE `pid` = 338 AND `status` = 1 ORDER BY `sort` ASC,`id` ASC LIMIT 0,10 [ RunTime:0.000336s ]
