SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 443091 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 443091 [ RunTime:0.001521s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (90940,94258,800203,922975,129575,601598,597286,92600,39438,492054,363619,191394,46841,810308,982763,886390,296419,494000,929366,120283,672068,754807,756617,68062,116358,259690,545956,677681,546476,778302,170676,508438,503463,521599,519760,99364,430167,304464,407643,556177,957710,5490,1027531,214752,773036,734915,353271,345352,110691,378654,690844,588144,32385,802117,34922,1043588,857502,165807,882095,617036) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 443091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000528s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 443091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]