SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 483819 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 483819 [ RunTime:0.002085s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (112326,1001161,1009916,744005,981789,7886,241105,1003158,755978,230880,465067,453248,471727,189335,846792,622300,990225,311601,843527,1025965,321076,180244,420439,621420,267971,698405,66731,943785,756145,846535,584724,594793,953368,803022,828196,876214,331620,644780,262917,309684,548481,418877,668914,675695,812351,345498,873173,259263,422048,537151,247900,54972,613759,691477,447524,712870,668915,58742,1041359,695671) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 483819 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 483819 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]