SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002044s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 980718 LIMIT 1 [ RunTime:0.001653s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 980718 [ RunTime:0.005558s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (25259,1012629,766509,168743,974382,641421,282683,347835,223681,884600,39431,978558,963376,309436,840051,603896,107891,130449,438871,1016569,648464,27945,214475,295952,987675,901802,911268,4592,564693,418943,336208,649344,789472,545155,564914,227236,733349,431107,338457,129845,901198,668796,529206,801635,529289,934059,154407,166171,260084,1023688,165906,516513,392545,137143,953919,158485,863474,664092,762811,195621) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 980718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000876s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 980718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001738s ]