SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001329s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 301138 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 301138 [ RunTime:0.002496s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (302481,949500,697988,946157,653547,475549,131128,391568,845717,16518,221307,613300,126048,918139,75351,863391,247675,32729,475564,408033,941203,377909,341421,557080,454489,640525,253612,735264,10738,714026,963215,796144,274477,1024542,60739,619181,835765,801703,1008717,34772,102547,623387,937994,136010,813471,322492,964680,6715,116754,835110,758754,765251,241603,711295,275635,54652,825413,1018458,625377,128435) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 301138 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 301138 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000471s ]