SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001449s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 355064 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 355064 [ RunTime:0.001644s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (842347,856212,896745,796314,241235,272020,442208,55820,98739,242176,779124,736940,1022164,806151,10589,686555,175280,505217,1027645,404788,179052,573784,60230,891417,434382,176946,405849,510740,707835,742102,890990,790243,826142,916259,692583,325471,861367,208494,563929,934478,802463,584427,275952,801776,150683,407537,710705,165550,764377,325797,858850,660276,198670,990997,321563,564212,988228,894575,188735,774319) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002732s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 355064 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000503s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 355064 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000803s ]