SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34486 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34486 [ RunTime:0.005980s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (546694,200981,938753,797333,923902,322571,154243,135009,908032,760354,1007075,83709,275244,542013,256685,861953,933186,442726,260100,910776,865552,809496,446583,1048039,291314,523158,278066,17802,52790,519494,1038797,400710,183513,76750,975235,2722,777529,751262,736980,745978,158962,438336,445056,151224,269178,159089,344134,266807,1018484,916579,1017000,726966,570718,79327,470012,331886,1003980,627207,86670,519153) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34486 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34486 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000810s ]