SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038222 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038222 [ RunTime:0.001968s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (916271,297955,724843,907336,1013995,174848,46393,930004,363116,778030,266980,786874,264253,626320,114500,58407,227111,997531,78744,99518,53405,734124,881216,274060,946467,429413,257465,554600,548812,337063,33351,451272,138132,52454,322336,982439,744108,877947,858451,911261,284095,435111,816241,969865,60591,287655,123212,146272,339633,602636,135520,364249,122429,864253,164588,338488,793955,294580,385437,128567) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038222 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038222 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]