SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 205110 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 205110 [ RunTime:0.003269s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (132840,241066,49821,592768,683191,891630,1048793,815574,710189,254014,1029600,326570,495534,884764,401741,200272,741560,98111,726680,154651,348234,877026,337559,432994,462175,176027,212774,420085,13048,221783,885486,600276,266341,718895,875571,919816,115618,595342,797611,1026789,378058,933503,976105,736078,119215,840078,777388,524070,95239,514273,414202,1008399,857892,179392,590862,366813,708205,77438,425214,772567) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 205110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 205110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]