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` = 419967 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419967 [ RunTime:0.001472s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (443839,608682,388619,431376,407590,304478,984487,26827,779010,848080,783177,491566,541912,78413,680978,965166,656213,189617,720107,567392,678680,107068,145113,770889,1004721,727503,535135,725061,976153,828102,483985,272296,988738,480054,497300,939185,374627,22287,268287,50445,161484,278960,576306,939208,700586,827536,505582,972339,722824,330339,907041,389163,307195,397482,640697,398100,440435,820267,591952,52574) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419967 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419967 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]