SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467933 LIMIT 1 [ RunTime:0.000461s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467933 [ RunTime:0.003406s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (987494,367771,871785,453126,998123,72689,773631,594761,561574,424118,859149,628620,446015,24857,761846,70517,209599,595352,409435,660279,853907,108269,572904,385087,772422,963439,801649,450132,377516,912942,624033,6344,137141,552939,759141,568265,495435,223437,525736,989271,676115,388320,788209,857980,859689,336436,943593,361666,336226,299956,1003472,1045770,203140,904671,624532,369414,933269,998795,975139,504185) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467933 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467933 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]