#0 [time:0.0001s] SET character_set_connection=utf8mb4, character_set_results=utf8mb4, character_set_client=binary, sql_mode=''
#1 [time:0.0003s] SELECT * FROM le_runtime WHERE k='cfg' LIMIT 1 [explain type: const | rows: 1]
#2 [time:0.0005s] SELECT * FROM le_kv WHERE k='og_meta_tags' LIMIT 1 [explain type: const | rows: 1]
#3 [time:0.0001s] SELECT * FROM le_kv WHERE k='schema_markup' LIMIT 1 [explain type: const | rows: 1]
#4 [time:0.0001s] SELECT * FROM le_kv WHERE k='template_class_obfuscate' LIMIT 1 [explain type: const | rows: 1]
#5 [time:0.0001s] SET character_set_connection=utf8mb4, character_set_results=utf8mb4, character_set_client=binary, sql_mode=''
#6 [time:0.0003s] SELECT * FROM le_cms_search WHERE id = 588 LIMIT 1 [explain type: const | rows: 1]
#7 [time:0.0004s] SELECT * FROM le_kv WHERE k='navigate' LIMIT 1 [explain type: const | rows: 1]
#8 [time:0.0013s] SELECT cid FROM le_category ORDER BY orderby ASC ,cid ASC [explain type: ALL | rows: 142]
#9 [time:0.0033s] SELECT * FROM le_category WHERE cid='1' OR cid='2' OR cid='3' OR cid='4' OR cid='5' OR cid='6' OR cid='7' OR cid='8' OR cid='9' OR cid='11' OR cid='12' OR cid='13' OR cid='14' OR cid='15' OR cid='16' OR cid='17' OR cid='18' OR cid='19' OR cid='20' OR cid='21' OR cid='22' OR cid='23' OR cid='24' OR cid='25' OR cid='26' OR cid='27' OR cid='28' OR cid='29' OR cid='30' OR cid='31' OR cid='32' OR cid='33' OR cid='34' OR cid='38' OR cid='39' OR cid='40' OR cid='41' OR cid='42' OR cid='43' OR cid='44' OR cid='45' OR cid='46' OR cid='47' OR cid='48' OR cid='49' OR cid='50' OR cid='51' OR cid='52' OR cid='53' OR cid='54' OR cid='55' OR cid='56' OR cid='57' OR cid='58' OR cid='59' OR cid='60' OR cid='61' OR cid='62' OR cid='63' OR cid='64' OR cid='65' OR cid='66' OR cid='67' OR cid='68' OR cid='69' OR cid='70' OR cid='71' OR cid='72' OR cid='73' OR cid='74' OR cid='75' OR cid='76' OR cid='77' OR cid='78' OR cid='79' OR cid='80' OR cid='81' OR cid='82' OR cid='83' OR cid='84' OR cid='85' OR cid='86' OR cid='87' OR cid='88' OR cid='89' OR cid='90' OR cid='91' OR cid='92' OR cid='93' OR cid='94' OR cid='95' OR cid='96' OR cid='97' OR cid='98' OR cid='99' OR cid='100' OR cid='101' OR cid='102' OR cid='103' OR cid='104' OR cid='105' OR cid='106' OR cid='107' OR cid='108' OR cid='109' OR cid='110' OR cid='111' OR cid='112' OR cid='113' OR cid='114' OR cid='115' OR cid='116' OR cid='117' OR cid='118' OR cid='119' OR cid='120' OR cid='121' OR cid='122' OR cid='123' OR cid='124' OR cid='125' OR cid='126' OR cid='127' OR cid='128' OR cid='129' OR cid='130' OR cid='131' OR cid='132' OR cid='133' OR cid='134' OR cid='135' OR cid='136' OR cid='137' OR cid='138' OR cid='139' OR cid='140' OR cid='141' OR cid='142' OR cid='143' OR cid='144' OR cid='145' OR cid='146' [explain type: ALL | rows: 142]
#10 [time:0.0058s] SELECT a.id, a.cid, a.title, a.intro, a.dateline as date, 'article' as type
FROM le_cms_article a
WHERE a.tags LIKE '%"多特蒙德队 vs布拉格斯拉维亚队直播"%'
ORDER BY a.id DESC
LIMIT 50 [explain type: index | rows: 50]
#11 [time:0.0464s] SELECT liansai, home, away FROM le_cms_search WHERE title = '多特蒙德队 vs布拉格斯拉维亚队直播' LIMIT 1 [explain type: ALL | rows: 13693]
#12 [time:0.0006s] SELECT id, title, intro, matchdate as date, matchtime, team1, team2, flag1, flag2,
shorttitle, score1, score2, liveurl, 'match' as type
FROM le_cms_match
WHERE shorttitle = '无' OR team1 = '无' OR team2 = '无'
ORDER BY matchdate DESC, matchtime DESC
LIMIT 50 [explain type: index_merge | rows: 3]
#13 [time:0.0578s] SELECT id, title, intro, matchdate as date, matchtime, team1, team2, flag1, flag2,
shorttitle, score1, score2, liveurl, 'match' as type
FROM le_cms_match
ORDER BY matchdate DESC, matchtime DESC
LIMIT 50 [explain type: ALL | rows: 15097]
#14 [time:0.0002s] SELECT COUNT(*) as total FROM le_cms_search [explain type: | rows: ]
#15 [time:0.0002s] SELECT * FROM le_cms_search ORDER BY id DESC LIMIT 0, 8 [explain type: index | rows: 8]
#16 [time:0.0005s] SELECT id FROM le_cms_article WHERE type='新闻' ORDER BY id DESC LIMIT 0,6 [explain type: index | rows: 6]
#17 [time:0.0005s] SELECT * FROM le_cms_article WHERE id='1501' OR id='1500' OR id='1499' OR id='1498' OR id='1497' OR id='1496' [explain type: range | rows: 6]
