SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 29108 LIMIT 1 [ RunTime:0.000278s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 29108 [ RunTime:0.002155s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (250125,735701,578486,136968,22158,835374,464784,367497,221150,860114,363727,828264,910912,331756,51796,537940,332884,111809,784836,421767,267119,510339,1011872,741952,292001,127149,203404,96945,510543,517972,591214,13008,341196,459390,994742,384934,651779,464100,113308,164324,490973,814922,804954,780890,933019,980597,102273,635702,141238,448960,13342,837950,222030,629914,854630,727245,850653,89431,140294,716784) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005897s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 29108 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 29108 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]