SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 628899 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 628899 [ RunTime:0.002951s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (394104,1027066,42847,436129,472947,542571,70254,704443,691406,419818,383863,9864,822238,142441,518557,651668,87350,616993,129609,250798,203632,687800,201763,920409,146420,31593,407448,499597,556920,772484,736759,214820,703909,51742,951196,714459,867201,866123,1026851,803140,333345,1048740,147284,313456,135056,495179,112792,159463,158670,734745,1026775,603582,881987,865444,169271,170255,164876,1042513,260938,1010509) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 628899 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000596s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 628899 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000650s ]