SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 315954 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 315954 [ RunTime:0.001858s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (159223,60292,594928,717043,808712,850126,367141,414232,669866,571249,495703,78634,1029816,754151,980793,512562,601690,804,527915,12650,175545,567061,303887,642765,663013,712828,945768,972430,141550,560280,283138,803818,701778,290744,612771,970416,532792,268726,200177,782118,342980,580389,206474,79801,450778,740879,905106,229285,453217,552488,177836,12720,1044214,655960,825625,276194,531640,350276,25772,941303) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 315954 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 315954 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002535s ]