SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001410s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 994080 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 994080 [ RunTime:0.002116s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (264002,723190,860154,320805,239182,530215,341308,120873,120859,646476,918228,373668,383320,409048,31018,570437,139508,529863,336179,533789,623674,751675,351650,252650,360035,101778,523232,563938,710041,513999,538290,248230,685285,719035,310281,1047793,505176,496668,86013,214151,157377,923445,513664,398532,23937,579433,913148,329025,730236,994877,781439,239731,175421,574388,851648,961344,792908,474943,617200,854108) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 994080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 994080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000717s ]