SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43484 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43484 [ RunTime:0.002234s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (87361,1019458,194970,270160,856364,577196,374130,1041920,510119,1005601,559949,461574,564848,283654,143010,486777,397004,1007070,819037,545306,564205,855452,165467,697239,821563,642000,977092,590522,792443,923223,86486,103694,324526,283634,462308,379942,903670,639054,205715,288227,363371,286577,732005,47248,361680,132147,150164,689610,951587,616432,429566,256534,1022863,704191,620830,609054,282330,99474,383985,512159) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43484 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43484 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]