SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001851s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456307 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456307 [ RunTime:0.003495s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (810707,421604,890361,1010795,427238,824322,13022,105194,547845,709526,853813,473245,920851,490553,204153,407255,175435,931330,723913,891488,567503,4744,224470,422857,1011815,822770,218,276194,389673,827142,221283,531337,740015,313313,437925,990027,327225,959987,719093,452767,569176,771785,131470,976434,568403,104002,644423,68126,665021,960373,346747,514026,769062,100301,831608,961605,480543,741998,846128,134045) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456307 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456307 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000463s ]