1. The data needs to be seriated before it can be analyzed. (数据在进行分析之前需要进行排序。)
2. The books on the shelf are seriated by author's last name. (书架上的书按照作者的姓氏进行排列。)
SHOW FULL COLUMNS FROM `tool_word` [ RunTime:0.001214s ]
SELECT `id`,`word`,`british`,`american`,`jbjs`,`wlsy`,`cx`,`lz` FROM `tool_word` WHERE `switch` = 1 AND `id` = 82738 LIMIT 1 [ RunTime:0.000852s ]
UPDATE `tool_word` SET `views` = `views` + 1 WHERE `id` = 82738 [ RunTime:0.001576s ]
SELECT `id`,`word` FROM `tool_word` WHERE `id` IN (92772,69387,64922,82554,44442,101907,809,57196,87116,96145,40457,35864,46933,26550,74466,48296,46541,100793,58610,52869,26540,26202,64562,17908,51761,44867,8623,11286,11513,81441) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.016819s ]
SELECT `id`,`word` FROM `tool_word` WHERE `id` < 82738 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`word` FROM `tool_word` WHERE `id` > 82738 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002941s ]