SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001671s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 236432 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 236432 [ RunTime:0.001679s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410529,267047,430313,104572,275634,428066,962363,444234,859712,586321,84639,330607,24089,962092,70036,618799,254030,855981,648345,617808,226013,1033871,1032010,684920,992929,772189,737204,803920,993694,485087,4263,1045620,861133,978361,896250,850611,294732,911394,1024969,401749,238512,128704,149784,660942,206524,454066,149824,851315,460047,813822,559066,335245,391658,319338,529105,575107,38780,414937,1013786,222300) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 236432 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002612s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 236432 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]