SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 289041 LIMIT 1 [ RunTime:0.000879s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 289041 [ RunTime:0.001847s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (818014,136316,566758,324090,673580,972588,350374,529337,625292,639879,887004,252057,479364,422941,93023,1046267,690216,111068,853655,258103,506893,515287,120765,516540,472804,563956,527430,284860,968897,900257,871895,508461,48298,61519,918970,355968,766884,334783,661863,943407,139479,210352,273351,370509,703180,594249,619285,786797,691630,983659,271454,940051,899289,36545,872139,701592,96939,214083,110970,722350) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 289041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 289041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001065s ]