SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201199 LIMIT 1 [ RunTime:0.000562s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201199 [ RunTime:0.001281s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (44224,320016,959383,525353,601371,11040,638718,931791,170152,846481,264361,512179,22175,154315,935118,651615,487385,474158,1008502,191937,570745,939518,270744,258868,371971,1016473,89855,691089,598761,924409,167849,112393,419444,270456,298520,111375,834347,434332,807347,753598,977179,629424,106556,424282,392328,1018355,775852,701855,925938,319898,955898,765326,79055,117156,499859,958588,866745,502409,342840,764794) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201199 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201199 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]