SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520981 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520981 [ RunTime:0.001782s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (144223,673919,3862,347561,2771,777576,499123,800464,648284,771708,795335,467486,241940,53156,722838,674747,596280,569298,85172,480404,218056,512267,633821,483871,703116,1023701,311643,640777,694760,1005584,308972,300515,17318,514596,134643,833537,151625,558856,805643,974387,70473,1033752,519283,248558,131265,85636,900356,223589,514381,82080,11532,540231,431951,709198,263917,902373,6671,335589,86459,474641) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520981 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520981 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]