SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001405s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50091 LIMIT 1 [ RunTime:0.001268s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50091 [ RunTime:0.007531s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (86118,502810,305407,29673,1000557,324824,583797,75219,700787,446857,1020242,189975,52049,514227,827075,291214,618764,630631,503475,950837,278240,463871,80416,76866,727661,835272,443003,741783,993396,589305,182006,256106,188928,738941,848452,471694,505462,827626,218927,164244,558443,510718,521207,417213,876044,934709,881960,426116,443002,347654,180389,875679,1020531,602767,936024,577970,717458,689702,229350,787483) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001721s ]