SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002926s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 494051 LIMIT 1 [ RunTime:0.001015s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 494051 [ RunTime:0.002587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (349508,254129,912059,524942,649152,879557,461982,591568,824532,370231,411681,799110,481862,556238,371281,531812,979655,424317,809129,201219,384395,68021,860671,230666,92582,137245,438501,173352,898709,821152,828911,872787,224911,798028,211483,211972,608238,733315,383552,947023,1009812,127759,96464,1041246,626440,98129,684981,727161,653988,583453,357572,837944,679294,356323,947354,662223,675743,610046,909561,390021) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001786s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 494051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000612s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 494051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000835s ]