SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481429 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481429 [ RunTime:0.002627s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (325192,484358,145747,753378,996675,634643,163831,514606,548656,880344,830373,543304,118137,554090,534461,680103,848137,352456,632944,74335,38081,898637,864518,318196,559246,732505,822740,502054,58479,1005050,386389,614794,124316,409745,58986,848074,154387,136354,225696,225677,749137,55898,924882,844465,402151,734322,91095,846397,307589,769712,364366,125855,875546,328876,359212,982147,887564,63088,560808,1001311) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481429 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481429 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]