SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481092 LIMIT 1 [ RunTime:0.002483s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481092 [ RunTime:0.003673s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (906113,962323,456228,480065,93147,145125,296785,168742,800797,575517,220921,152373,651710,437221,324237,844278,505504,391561,991538,113983,599953,185366,674060,713100,71085,319151,129581,737583,593618,965605,257916,807935,442388,523336,276593,989141,768902,417029,1035241,46679,223904,461515,588567,539672,297229,909574,548029,501969,295102,559466,455490,615865,186184,473105,813809,202118,981111,925241,84707,260965) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481092 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481092 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000752s ]