SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 686098 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 686098 [ RunTime:0.001773s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (460072,850203,597251,680533,124724,1009613,292198,365053,468292,417471,910438,569151,843744,412581,99015,542148,798396,515629,750901,209395,258496,183920,626207,102362,843463,58241,492085,145033,711571,571126,801632,576752,15355,21988,915950,238178,247401,270465,497240,491915,380836,428125,725338,580008,290262,586130,577004,580580,247080,68446,54364,235240,602913,728229,753751,19003,982099,410447,436789,751620) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 686098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 686098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]