SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424101 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424101 [ RunTime:0.001635s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (525627,467713,1026787,936052,632901,848795,764184,713640,358310,839349,480930,664147,863094,95313,382544,734888,354980,431013,1029449,340654,760287,841333,532100,468171,145280,93644,402275,456936,718545,26995,109549,92014,1017771,19172,273509,743317,996701,294220,914555,722550,683293,842856,690319,285235,962577,736995,249664,98011,268509,409910,412318,66539,110963,57915,229247,185492,1009709,765100,5585,183187) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000950s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]