SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 197912 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 197912 [ RunTime:0.001574s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (308961,279367,258882,503849,570369,497666,672577,1047559,448352,43754,897341,531738,428914,686499,839495,167573,732033,483984,182294,583903,58349,791944,575004,127455,394747,870044,618556,585395,216735,722265,909224,987767,769315,538100,200838,252958,423200,894999,8625,606785,232676,165095,741910,569960,899014,742520,168910,275440,603189,190452,771499,740861,719881,1042070,383172,225337,290841,897921,147868,554842) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 197912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 197912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]