SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001362s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455589 LIMIT 1 [ RunTime:0.000484s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455589 [ RunTime:0.004428s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1013064,19672,677902,737126,1023629,475054,211174,411709,830854,702836,655384,356024,323875,492035,589873,435462,106298,709525,211006,249567,502360,705233,724962,396608,616500,821171,255441,897309,36555,595613,590935,530824,297272,438674,389016,801558,876410,980247,202703,962808,878789,488966,250404,6445,906987,720581,563647,122453,151840,25561,148197,69445,834339,840882,223093,889481,999310,99813,151579,579433) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455589 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455589 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]