SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012154 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012154 [ RunTime:0.001549s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (270846,497343,327968,928822,472879,121863,115945,695435,220379,1034414,766424,968829,791772,777831,725823,181010,898396,803575,872204,1003975,131853,608890,303334,1023263,262158,337886,362969,858155,694123,992806,119789,879096,197804,996200,497304,27289,258771,397469,542004,780788,877376,902376,408487,48346,274883,490744,556854,808972,340039,817308,673365,574383,483911,900160,719214,534423,861008,315139,940289,271397) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012154 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012154 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000423s ]