SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428520 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428520 [ RunTime:0.002097s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (282648,873801,975384,781987,895349,755677,86486,541900,76795,963958,272566,41559,312536,795228,194703,926921,805854,100133,642439,854865,4672,190775,133507,669377,125710,770586,460997,530180,324672,744956,204089,116714,669384,126802,552562,708992,677910,497849,8362,1038084,483968,1023567,548064,615497,110050,33729,150177,249764,27839,520294,815579,637531,992256,376121,553451,211023,200941,680618,733576,721714) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428520 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428520 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000697s ]