SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 432091 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 432091 [ RunTime:0.001883s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (192783,893897,536182,682771,515876,49513,962234,734777,947470,652324,989566,967143,514599,32375,343751,453722,1012078,98385,596669,917003,1023474,659860,260133,428234,1008402,904565,797082,453131,713882,1021265,517507,511494,679802,1019439,823037,577219,995308,855097,699255,280096,237147,994546,93949,141191,858115,788765,542698,381083,680835,73374,63765,175573,679055,903158,999556,850332,40992,825609,917795,748953) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 432091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 432091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]