SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102616 LIMIT 1 [ RunTime:0.000292s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102616 [ RunTime:0.002633s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (651476,599718,75316,342286,369343,405864,1017807,232275,375835,405061,1024827,859810,809597,24651,785410,278139,744734,167047,9695,522005,526475,330232,324902,851648,203569,707308,537242,662538,874114,216654,530458,385195,20492,927386,140622,83237,116207,434748,827684,701973,775125,260595,397338,312941,921949,503335,837979,689089,933025,758790,50382,916943,527746,672360,997335,348853,92959,836445,705304,875702) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102616 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102616 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]